Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor

Count distinct OR

Hi everyone,


I have an count expression that works really well in a table;

Count(DISTINCT {$<Punten={'GeenEis'},JaarBehaald={'GeenEis'},JaarOpgestart={'GeenEis'},leervak={'GeenEis'}>} KEY )


My problem is that i have 3 columns;

Column1  contains 'J' or 'N'

Column2  contains 'J' or 'N'

Column3  contains 'J' or 'N'

I only want my expression to apply to the lines where Column1 = 'J' OR Column2 = 'J'.

At this moment it applies to all 3 columns,


Any idea how i can do this?


Thank you so much in advance,


Labels (1)
1 Reply

Re: Count distinct OR

Not sure how you expression is linked to these conditions? Would you be able to provide some more details and/or a sample?