Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm a bit confused about what I'm about to describe, would appreciate some help.
I'm trying to figure out how I can compare data that gets reduced down as I click more and more options against some fixed values that I want to set.
So for example, I have two fields that I have loaded into QlikView. One of them is CallRef and the other is Team. Team could be one of two values - TeamA and TeamB.
I need some way to store the total number of calls that are linked to TeamA and use that to compare other data to. Is there a way that I can store this value globally (ideally as part of the load script) so that it's always there for me to make comparisons against?
You can store it as a variable.
Settings > Document Properties > Variables
The variable would contain something like:
=count({<Team = {'Team A'}>}Calls)