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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculate besed on unfiltered dataset

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?

1 Solution

Accepted Solutions
maxgro
MVP
MVP

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




View solution in original post

2 Replies
maxgro
MVP
MVP

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




Not applicable
Author

THank you very much! Wil read up on it now. Just needed to be pointed in correct direction.