Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help with fixed values?

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?

1 Reply

You can store it as a variable.

Settings > Document Properties > Variables

The variable would contain something like:

=count({<Team = {'Team A'}>}Calls)