Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm very new to Qlikview. Can someone please explain what this mean in an expression used in one of
Pivot Chart that I'm trying to troubleshoot?
=Count( {$<Col1Flag={1}, Col2Flag={0}>}DISTINCT (Col3) )
Thank you
=Count( {$<Col1Flag={1}, Col2Flag={0}>}DISTINCT (Col3) )
Count of Distinct Col3 with condition Col1Flag = 1 and Col2Flag = 0
Hi Manish,
Got it. Thanks for the help!
this expression counts the number of distinct values in col3 where the its associated Col1Flag=1 and Col2Flag=0
eg:
col1flag, col2flag, col3
1, 1, A
1, 0, A
0, 1, A
1, 0, A
1, 1, B
1, 0, B
0, 1, B
1, 0, B
=Count( {$<Col1Flag={1}, Col2Flag={0}>}DISTINCT (Col3) ) expression gives a count value of 2
col1flag, col2flag, col3
1, 0, A
1, 0, B
if theres no disti9nct keyword i.e
=Count( {$<Col1Flag={1}, Col2Flag={0}>}(Col3) ) expression gives a count value of 4
col1flag, col2flag, col3
1, 0, A
1, 0, A
1, 0, B
1, 0, B
hope this helps.
Great, thanks you! Your sample really helps.
Awesome. do you please mind closing the thread as answered if you got what you looking for.
Krishna