topic Re: Dynamically Change Expressions in QlikView

Dynamically Change Expressions

Josh_Good — Wed, 03 Apr 2013 16:50:03 GMT

This videos will show you how to dynamically change expression in QV using an single control. The resulting QVW is also attached.

http://youtu.be/QSJhYdJHHjA

Re: Dynamically Change Expressions

kaushiknsolanki — Wed, 03 Apr 2013 18:40:35 GMT

Hi,

Josh I liked the video and it is a really good trick.

But i would suggest you to create a document instead of post, the reason is that later date it will be hard to find the post then document.

Also you can describe in words what you tried to do conceptually.

Regards,

Kaushik Solanki

Re: Dynamically Change Expressions

Fri, 01 Aug 2014 12:43:28 GMT

This is a good trick but you need to select only one metric at a time and at least one metric must be chose.

Here is a better solution from John Witherspoon: Execute Set Analysis stored in a table

Regards,

Patrick

Re: Dynamically Change Expressions

timanshu — Fri, 27 Feb 2015 07:30:27 GMT

Hi Josh,

I have fields with spaces in that, then the expression =sum($(=%metric)) does not work. How to resolve this?

Re: Dynamically Change Expressions

Fri, 27 Feb 2015 13:36:43 GMT

Just add the brackets i.e. [Dollar Amount] in your variable expressions.

Re: Dynamically Change Expressions

Josh_Good — Fri, 27 Feb 2015 13:57:10 GMT

Hi Timanshu,

Try this:

=sum($(='[' & %metric & ']'))

-Josh

Qlik

Re: Dynamically Change Expressions

agomes1971 — Fri, 27 Feb 2015 15:37:15 GMT

Hi,

the use of dynamic expressions here:

QlikView How To (or Tips & Tricks) Application

Regards

André Gomes

Re: Dynamically Change Expressions

timanshu — Sat, 28 Feb 2015 10:18:32 GMT

Thank you Josh It works.

Re: Dynamically Change Expressions

ebc — Mon, 02 Mar 2015 16:59:24 GMT

I have a similar challenge. Instead of creating a table with metric field names I want to actually load an entire expression that gets dynamically evaluated.

Is it possible with $ expansions to move the "Sum" function in to the actual field and using $ expansion on an entire formula?

Re: Dynamically Change Expressions

Josh_Good — Thu, 05 Mar 2015 02:10:55 GMT

Eric,

Take a look at this posting. Reusing Expressions

-Josh

Qlik

Re: Dynamically Change Expressions

Tue, 28 Apr 2015 20:51:50 GMT

Hey Josh,

Thank you so much for this tip. This is extremely helpful to someone who is new to Qlikview and has a rather steep learning curve to overcome with little time and a large number of requests to address.

I am running into a complication with a chart that utilizes numerous expressions. What I have is a chart with expressions like, freight, labor, materials, waste, that are all associated to a single order. These are stacked columns in the chart and I have all of the orders listed in the chart. Based on what you showed in the video above, I was hoping that I could use this to allow users to select just the freight, or the materials to see the associated costs by each order. However, it still loads all of the values, but it seems to sort them differently (perhaps by the selected expression?). Additionally, there doesn't seem a way from this video to be able to select all of the fields in the Listbox. When I do that, I receive a no data to display value in the chart. Hope you can help me out.

Thanks,

Chris

Re: Dynamically Change Expressions

ebc — Fri, 01 May 2015 18:28:46 GMT

Hi Chris,

What Josh was able to accomplish in the video was to dynamically select and display a single measurement across multiple different visualizations. In your chart this would be accomplished by creating a single expression where you sum the metric (freight, labor, etc) of course displayed by the orders dimension. This of course requires one and only one metric selected at a time.

It sounds like you would like to display one to many of these metrics all at the same time (based on user selection). In this case you would have to create separate expressions for every metric and is the conditional show (or hide) feature based on the users selection.

Re: Dynamically Change Expressions

Mon, 26 Oct 2015 17:54:05 GMT

I've been working with this example but am having trouble applying it to a boxplot. My expressions have both a dimension and the measure that changes, but when I have referenced metrics of my own the way %metric items would be referenced, it doesn't want to accept the inline load. When I remove the [...] brackets, it loads ok but doesn't reference the actual metric. Suggestions?

Re: Dynamically Change Expressions

vikasmahajan — Tue, 27 Oct 2015 04:03:00 GMT

Nice ..

Vikas

Re: Dynamically Change Expressions

Fri, 04 Dec 2015 12:37:14 GMT

This is literally awesome and works very well.

The only obstacle is when using the standard document clear all function (or buttons for that matter), it clears the pickmetric filter - is there a way around this?

Have tried using a button with Clear Other Fields and %pickmetric but this doesn't even seem to clear anything.

Any help appreciated

Re: Dynamically Change Expressions

Fri, 04 Dec 2015 12:54:53 GMT

Just figured it out...

Create a list box for %pickmetric and place in hidden tab or similar.

Set the List box to 'Always One Selected Value'.

Clear selections will then clear everything except one of the values in the %pickmetric box