Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Not applicable

Adding another value to set analysis.

Hi there,


I am trying to add another expression to my set analysis and I am having a bit of trouble.

COUNT({<YEAR = {'$(=Year(Today()))'}>} DISTINCT CustomerID)

I need to add the following to the set analysis:

COUNT({$<Sales_Total={">0"}>}  Sales_Total)


Any help will be appreciated.

Thanks.

Tags (1)
3 Replies
okolyug16
Contributor II

Re: Adding another value to set analysis.

Try this COUNT({<YEAR = {'$(=Year(Today()))'}, Sales_Total={'>0'}>} DISTINCT CustomerID)

MVP & Luminary
MVP & Luminary

Re: Adding another value to set analysis.

Hi,

Try this

COUNT({<YEAR = {'$(=Year(Today()))'}, Sales_Total={">0"}>} DISTINCT CustomerID)


Like this you can add any number filters in Set analysis.


Regards,

jagan.

jayaseelan
Contributor III

Re: Adding another value to set analysis.

Hi,

For finding count of customerID according to your filtration is below,

COUNT({<YEAR = {'$(=Year(Today()))'}, Sales_Total={">0"}>} DISTINCT CustomerID)

For finding count of Sales_Total according to your filtration is below,


COUNT({<YEAR = {'$(=Year(Today()))'}, Sales_Total={">0"}>} DISTINCT Sales_Total )



Thanks,