Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Two days into Qlikview: I am trying to set a min value for a guage chart using the minimum value of the entire dataset. I would like to stay the same after every load based on any new data, and not be affected by the filtering a user selects. Is there a function that can be used to reference the unfiltered dataset?
set analysis, 1 identifier {1}; see online help for detail or Set Analysis: syntaxes, examples
=sum({1} value)
=min({1} somefield)
or you can calculate in the script and save in a variable
set analysis, 1 identifier {1}; see online help for detail or Set Analysis: syntaxes, examples
=sum({1} value)
=min({1} somefield)
or you can calculate in the script and save in a variable
THank you very much! Wil read up on it now. Just needed to be pointed in correct direction.