topic Re: Set analysis with alternate state in QlikView

Set analysis with alternate state

Fri, 18 Oct 2013 03:01:05 GMT

=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

Re: Set analysis with alternate state

jagan — Fri, 18 Oct 2013 04:44:47 GMT

Hi Ram,

Try this

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

Regards,

Jagan.

Re: Set analysis with alternate state

jagan — Fri, 18 Oct 2013 04:46:07 GMT

Hi,

Checkt this also, hope it helps you.

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

Regards,

Jagan.

Re: Set analysis with alternate state

er_mohit — Fri, 18 Oct 2013 05:27:13 GMT

try this way

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