Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This videos will show you how to dynamically change expression in QV using an single control. The resulting QVW is also attached.
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
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
Hi Josh,
I have fields with spaces in that, then the expression =sum($(=%metric)) does not work. How to resolve this?
Just add the brackets i.e. [Dollar Amount] in your variable expressions.
Hi Timanshu,
Try this:
=sum($(='[' & %metric & ']'))
-Josh
Qlik
Hi,
the use of dynamic expressions here:
QlikView How To (or Tips & Tricks) Application
Regards
André Gomes
Thank you Josh It works.
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?