Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Non Performing Dealers having Zero Sales

Hi All,

I need to find out the No of Non Performing Dealers who having Zero Sales ?? Can any One give me Idea??

Thanks in advance

Regards

Deepak

3 Replies
Not applicable

Re: Non Performing Dealers having Zero Sales

Hey Deepak,

To get a count of the dealers with 0 sales i have used :

=count(if(Sales=0,1))

To get a list of the dealer names this expression may solve your problem:

=if(Match(0,[Sales]),Dealer)

nizamsha
Valued Contributor

Re: Non Performing Dealers having Zero Sales

if(sum(sales)=0,1,sales)

or if( count(sales)=0,1,Sales)

Not applicable

Re: Non Performing Dealers having Zero Sales

if(sales=0 or sales=' ',Dealers)

Community Browser