Dynamically Change Expressions

[Josh_Good]

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

[kaushiknsolanki]

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

[#3]

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

[timanshu]

Hi Josh,

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

[#5]

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

[Josh_Good]

Hi Timanshu,

Try this:

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

-Josh

Qlik

[agomes1971]

Hi,

the use of dynamic expressions here:

QlikView How To (or Tips & Tricks) Application

Regards

André Gomes

[timanshu]

Thank you Josh It works.

[ebc]

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?

[Josh_Good]

Eric,

Take a look at this posting. Reusing Expressions

-Josh

Qlik