Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
Showing results for 
Search instead for 
Did you mean: 

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

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