Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Thanks Gysbert Wassenaar, Really helpful answer let me check the scenarios what you had given
Thanks Gysbert Wassenaar, Really helpful answer let me check the scenarios what you had given