Qlik Community

App Development

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

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jonathan_ineox
Contributor III
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
Creator
Creator

All good apart from DISTINCT rather than Distincts


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

View solution in original post

11 Replies
aronwilliamson
Creator
Creator

All good apart from DISTINCT rather than Distincts


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

View solution in original post

jonathan_ineox
Contributor III
Contributor III
Author

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

shanky1907
Creator II
Creator II

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
Creator II
Creator II

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

shanky1907
Creator II
Creator II

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

jonathan_ineox
Contributor III
Contributor III
Author

it's the same?

shanky1907
Creator II
Creator II

What conditions you want to add?

jonathan_ineox
Contributor III
Contributor III
Author

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

shanky1907
Creator II
Creator II

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)