Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=count({< [Order type] = {'Indent'}, [Sales]={"=0"}*Season1 ,[Customer Name]={"=max(aggr(sum([Sales]),[Customer Name]))"} *Season1 >} distinct [Customer Name])
Hi, I have the above expression where i want to get the count of customers that haven't done sales, but based on the alternate state 'Season1'. Somehow this always gives 0 as the result although i have customers with 0 sales.
Can someone help please?
Thanks,
Ram
Hi Ram,
Try this
=count({< [Order type] = {'Indent'}, [Sales]={"=0"} , [Customer Name]=[Season1]::[Customer Name] >} distinct [Customer Name])
Regards,
Jagan.
Hi,
Checkt this also, hope it helps you.
http://community.qlik.com/message/209604#209604
Regards,
Jagan.
try this way
=count({Season1 }{< [Order type] = {'Indent'}, [Sales]={"=0"} ,[Customer Name]={"=max(aggr(sum([Sales]),[Customer Name]))"} >} distinct [Customer Name])