topic Re: Using if, sum, Total in the same Expression in QlikView

Using if, sum, Total in the same Expression

Wed, 05 Mar 2014 10:45:22 GMT

I have an expression as

sum(Total<A,B,C>Revenue)

I want to put an if condition in the same. When i put if condition in beginning like:

if(Quarter='Q1', sum(Total<A,B,C>Revenue),0)

it does not give any result.

How should i write the expression for it to work.

tresB — Wed, 05 Mar 2014 10:57:17 GMT

Had you have a dimension Quarter, your expression would work. Else, try like:

=Sum( TOTAL <A,B,C> If(Quarter='Q1', Revenue,0))

MK_QSL — Wed, 05 Mar 2014 11:04:20 GMT

=SUM(TOTAL <A,B,C> {<Quarter = {'Q1'}>} Revenue)

Wed, 05 Mar 2014 11:21:06 GMT

Hi Manish,

In Quarter I am trying to use an Alphanumeric variable. Its not working for that. Any change in syntax required?

Thanks and Regards,

Gaurang.

MK_QSL — Wed, 05 Mar 2014 11:22:59 GMT

Quarter = {'$(Variable)'}

sunilkumarqv — Wed, 05 Mar 2014 11:31:16 GMT

Try this

=if(Qtr>0,sum(Total<A,B,C> )Revenue)

maxgro — Wed, 05 Mar 2014 21:02:42 GMT

sum({$ <Quarter={'$(var)'}>} TOTAL <A,B,C> Revenue)