topic Re: Help with fixed values? in QlikView https://community.qlik.com/t5/QlikView/Help-with-fixed-values/m-p/383999#M1165642 <HTML><HEAD></HEAD><BODY><P>You can store it as a variable.</P><P></P><P>Settings &gt; Document Properties &gt; Variables</P><P></P><P>The variable would contain something like:</P><P></P><P>=count({&lt;Team = {'Team A'}&gt;}Calls)</P></BODY></HTML> Tue, 04 Sep 2012 16:24:01 GMT Nicole-Smith 2012-09-04T16:24:01Z Help with fixed values? https://community.qlik.com/t5/QlikView/Help-with-fixed-values/m-p/383998#M1165641 <HTML><HEAD></HEAD><BODY><P>I'm a bit confused about what I'm about to describe, would appreciate some help.</P><P></P><P>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.</P><P></P><P>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.</P><P></P><P>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?</P></BODY></HTML> Tue, 04 Sep 2012 16:10:27 GMT https://community.qlik.com/t5/QlikView/Help-with-fixed-values/m-p/383998#M1165641 2012-09-04T16:10:27Z Re: Help with fixed values? https://community.qlik.com/t5/QlikView/Help-with-fixed-values/m-p/383999#M1165642 <HTML><HEAD></HEAD><BODY><P>You can store it as a variable.</P><P></P><P>Settings &gt; Document Properties &gt; Variables</P><P></P><P>The variable would contain something like:</P><P></P><P>=count({&lt;Team = {'Team A'}&gt;}Calls)</P></BODY></HTML> Tue, 04 Sep 2012 16:24:01 GMT https://community.qlik.com/t5/QlikView/Help-with-fixed-values/m-p/383999#M1165642 Nicole-Smith 2012-09-04T16:24:01Z