Qlik set Analysis

prashantsanchet — Wed, 25 Apr 2018 10:05:02 GMT

Hi Team,

Scenario:

One business date will be always selected
For that business date we are adding ITDSales value for Business Date= Last Year Last date + YTDSales value for current business date
I have plotted this with one bar chart having customer as dimension and measure as following. :

Total ITDSales = if( Sum([Discount])>=1000,
num(Sum({$<BusinessDate={'$(=date(yearend([BusinessDate],-1), 'MM/DD/YYYY'))'}>}[ITDSales]) + sum([YTDSales]),'#,##0')
)

I want to count the only customer where Discount is greater than 1000. for above measure in chart
I am writing below expression but i am not getting exact count .

Total Customer Count

Count({<[Customer] ={"=Sum([Discount])>=1000"} >} distinct Customer)

Could you please help on same

Re: Qlik set Analysis

sunny_talwar — Wed, 25 Apr 2018 12:06:18 GMT

Try not to create duplicate threads

Qlik set analysis

topic Qlik set Analysis in App Development

Qlik set Analysis

Re: Qlik set Analysis