topic Re: Difference in QlikView

Difference

brindlogcool — Wed, 29 May 2013 16:50:03 GMT

What is the difference between

=Count (DISTINCT {$<Field1= Field1>} Field2)

and

=Count (DISTINCT {$<Field1= P(Field1)>} Field2)

P() will give the list of possible values and the default function of Qlikview is also provides the list of possible values based on the selection. How the P() is different from the defalution selection subset

Re: Difference

Gysbert_Wassenaar — Wed, 29 May 2013 17:02:43 GMT

Both are the same as Count (DISTINCT Field2).

The use of the p() function is usually when you use a set modifier inside it. For example to find customers that have sales this year, but also last year:

count({<Year={2013},Customer=p({<Year={2012}>}Customer)>} Customer)

count({<Year={2012,2013}>} Customer) would only count the customers that have sales in 2012 and/or 2013, not necessarily in both 2012 and 2013.

Re: Difference

brindlogcool — Wed, 29 May 2013 18:53:54 GMT

Thanks Gysbert Wassenaar, Really helpful answer let me check the scenarios what you had given

Re: Difference

brindlogcool — Wed, 29 May 2013 18:54:48 GMT

Thanks Gysbert Wassenaar, Really helpful answer let me check the scenarios what you had given