Set analysis with alternate state

[#1]

=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

[jagan]

Hi Ram,

Try this

=count({< [Order type] = {'Indent'}, [Sales]={"=0"} , [Customer Name]=[Season1]::[Customer Name] >} distinct [Customer Name])

Regards,

Jagan.

[jagan]

Hi,

Checkt this also, hope it helps you.

http://community.qlik.com/message/209604#209604

Regards,

Jagan.

[er_mohit]

try this way

=count({Season1 }{< [Order type] = {'Indent'}, [Sales]={"=0"} ,[Customer Name]={"=max(aggr(sum([Sales]),[Customer Name]))"} >} distinct [Customer Name])