Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
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.