topic Re: What is wrong in this if Statment? in QlikView

What is wrong in this if Statment?

Mon, 03 Dec 2012 09:06:38 GMT

=if(ySeg='Total',sum({1<ySeg={'S02','S03','S04'},yMonth={'$(=only(yMonth))'}>} yRev), yRev)

Please write the correct statement for this one.

I want to enter the sum of S02,S03,S04 in a grid against the Seg is Total.

Best Regards,

Gaurav Tyagi

Re: What is wrong in this if Statment?

swuehl — Mon, 03 Dec 2012 11:02:41 GMT

ySeg is your dimension and you want to check if your current line is a total line or a detail line? Something like this?

'Total' is just a label, not a dimension value you can check. Use dimensionality() function for this (or secondarydimensionality() with a pivoted dimension), something along these lines:

=if(dimensionality() = 0,sum({1<ySeg={'S02','S03','S04'},yMonth={'$(=only(yMonth))'}>} yRev), yRev)

edit: depending on the number of your dimensions you are calculating (sub-)totals for, you need to adapt the value you check against (i.e. zero in my sample).

Check the HELP for dimensionality() and also check using =dimensionality() as expression in your chart)

Re: What is wrong in this if Statment?

Tue, 04 Dec 2012 05:05:48 GMT

Thanks for the reply

'Total' is acctually a dimension.

I already changed my logic but will check this dimensionality function now.

Re: What is wrong in this if Statment?

Tue, 04 Dec 2012 05:34:28 GMT

Hi,

You may try like sum(if(......))

else attach some sample file, which will help to solve your prob....

Re: What is wrong in this if Statment?

sujeetsingh — Tue, 04 Dec 2012 05:53:40 GMT

just paste a sample and Explain what u want finally...