Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

jonathan_ineox
New Contributor III

Set Analysis

Hello,

I would like a confirmation for the sets analysis.

Count ({$ <date_ctrl_court = {'26/09/2017'}, Status = {'Sent'}>} Distincts card_number)

This Set analysis  count the number of card_number_dwhen the date_ctrl_court = {'26/09/2017'} and the status is sent?

1 Solution

Accepted Solutions
aronwilliamson
Contributor

Re: Set Analysis

All good apart from DISTINCT rather than Distincts


Count ({$ <date_ctrl_court = {'26/09/2017'}, Status = {'Sent'}>} Distinct card_number)

11 Replies
aronwilliamson
Contributor

Re: Set Analysis

All good apart from DISTINCT rather than Distincts


Count ({$ <date_ctrl_court = {'26/09/2017'}, Status = {'Sent'}>} Distinct card_number)

jonathan_ineox
New Contributor III

Re: Set Analysis

Thank you
So if I want to add filters just add the other fields?

shanky1907
Contributor II

Re: Set Analysis

Count ({$ <date_ctrl_court = {'26/09/2017'}, Status = {'Sent'}>} Distinct card_number)

or

Count ({<date_ctrl_court = {'26/09/2017'}, Status = {'Sent'}>} Distincts card_number)

shanky1907
Contributor II

Re: Set Analysis

Yes you can the same way. So count will be taken filtered out on all conditions

shanky1907
Contributor II

Re: Set Analysis

Count ({<date_ctrl_court = {'26/09/2017'}, Status = {'Sent'}>} Distinct card_number)

jonathan_ineox
New Contributor III

Re: Set Analysis

it's the same?

shanky1907
Contributor II

Re: Set Analysis

What conditions you want to add?

jonathan_ineox
New Contributor III

Re: Set Analysis

Like if date_fin={'26/30/2017'},

shanky1907
Contributor II

Re: Set Analysis

I assume the Date is not in correct format. lets take it as 26/10/2017 then


Count ({<date_ctrl_court = {'26/09/2017'}, Status = {'Sent'}, date_fin={'26/10/2017'}>} Distinct card_number)