topic Need help in writing the Expression in QlikView

Need help in writing the Expression

Fri, 21 Oct 2011 05:37:43 GMT

Good Morning All,

In a pivot table dimention is Sales Person and the expression is

=Sum(if(Aged='2/1-30 DAYS',[Value])) +Sum(if(Aged='3/31-60 DAYS',[Value]))+Sum(if(Aged='4/61-90 DAYS',[Value]))+Sum(if(Aged='5/90+DAYS',[Value])),

its working fine if the Sales Person has some values suppose if the Sales Person has no value means, I would like to display 0 or 'No Value'.

I have tried the following expression but it says error in the expression can anybody help me how to resolve this.

=If(Sum(if(Aged='2/1-30 DAYS',[Euro])) +Sum(if(Aged='3/31-60 DAYS',[Euro]))+Sum(if(Aged='4/61-90 DAYS',[Euro]))+Sum(if(Aged='5/90+DAYS',[Euro])),0,0,(Sum(if(Aged='2/1-30 DAYS',[Euro])) +Sum(if(Aged='3/31-60 DAYS',[Euro]))+Sum(if(Aged='4/61-90 DAYS',[Euro]))+Sum(if(Aged='5/90+DAYS',[Euro]))))

Regards

Chriss Mervin

Need help in writing the Expression

kaushiknsolanki — Fri, 21 Oct 2011 06:56:19 GMT

HI,

Try this expression and setting said below.

Expression

sum({<Aged = {'2/1-30 DAYS','3/31-60 DAYS','4/61-90 DAYS','5/90+DAYS'}>}EURO)

Now go to presentation tab and deselect "Supress Zero Values".

Hope this will solve your problem.

Regards,

Kaushik Solanki

Need help in writing the Expression

Fri, 21 Oct 2011 07:15:12 GMT

Dear Kaushik,

thanks for your help, its working fine.....

Regards

Chriss Mervin