Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
kristof_j
Creator III
Creator III

how to get values for $Field

Hi

Is there a way to get values when you have $Field as dimension?

If I make an alternate state I want to see the largest differences for almost all the fields.

I have the expressions I need but they only work if you select one field. But this is inefficient if you have many fields.

11 Replies
marcus_sommer

Have a look on this posting Re: Chart with count of $Field values, especially the QVFieldObserver.qvw from Ralf Becher and the min/maxstring(Concat($Field)) expressions - I think you could adapt it.

But how above mentioned such solutions need a lot of performance. Perhaps it is an alternatively to (pre) calculate these within the script.

- Marcus

marcus_sommer

In addition to the post above you could integrate the different states into these expressions but I think the whole approach is already (too) complex and if you it get work the performance will be very bad. So I think you should look for another way to answers your final aim.

- Marcus