Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

daaha_92
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?