topic Count, Distinct - need help in QlikView

Count, Distinct - need help

Anonymous — Thu, 23 Jul 2015 19:38:59 GMT

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

MK_QSL — Thu, 23 Jul 2015 19:42:02 GMT

=Count( {$<Col1Flag={1}, Col2Flag={0}>}DISTINCT (Col3) )

Count of Distinct Col3 with condition Col1Flag = 1 and Col2Flag = 0

Anonymous — Thu, 23 Jul 2015 19:49:17 GMT

Hi Manish,

Got it. Thanks for the help!

Qrishna — Thu, 23 Jul 2015 19:50:46 GMT

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, B

hope this helps.

Anonymous — Thu, 23 Jul 2015 19:54:09 GMT

Great, thanks you! Your sample really helps.

Qrishna — Thu, 23 Jul 2015 19:56:04 GMT

Awesome. do you please mind closing the thread as answered if you got what you looking for.

Krishna