Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Count IF distinct function.

Hi there,

trying to put together two expressions in one count 'if' statement.

count (DISTINCT if((option_1 + option_2 + option_3 + option_4 + option_5)>0,INDNR))


I need to include where other options are = 0 within the same expression to fetch the correct figure.

Thanks.

3 Replies
MVP
MVP

Re: Count IF distinct function.

Something like this?

Count(DISTINCT {<option_1 = {'>0'}>+<option_2 = {'>0'}>+<option_3 = {'>0'}>+<option_4 = {'>0'}>+<option_5 = {'>0'}>} INDNR)

Not applicable

Re: Count IF distinct function.

Something very much like this, need to get option 5 (for example):

<OPTION_5  = {'0'} ?


Would it be:

Count(DISTINCT {<option_1 = {'>0'}>+<option_2 = {'>0'}>+<option_3 = {'>0'}>+<option_4 = {'>0'}>+<option_5 = {'0'}>} INDNR)

SQL Looks like this when filtered.

(OPTION_1+ OPTION_2+ OPTION_3 + OPTION_4) >0

              AND                                                           

           (OPTION_5 + OPTION_6 ) = 0

       AND                                                          

           (OPTION_7 + OPTION_8 + OPTION_9) = 0

       AND                                                         

           (OPTION_10 + OPTION_11 + OPTION_12) = 0      

The count IF statement will need to count Option 1-5 (>0) and the other options to equal 0 (so they are not returned).

MVP
MVP

Re: Count IF distinct function.

I am not familiar with your data, but have you tried the above expression? Is it giving you the desired output?