topic Re: If stmt ? in QlikView

If stmt ?

Wed, 04 Jun 2014 05:13:10 GMT

Hi,

fabs(Sum({<[Transaction Type]={'C'},Year={2014},Month={'May'},Week={'18','19','20'}>}[Movement Quantity]))

Convert this set analysis into if Condition

Regards,

Helen

sujeetsingh — Wed, 04 Jun 2014 05:15:31 GMT

fabs(Sum(if([Transaction Type]='C' and Year=2014 and Month='May' and Week='18','19','20',[Movement Quantity]))

Hope it helps

Wed, 04 Jun 2014 05:30:28 GMT

Hi sujeet,

it was showing error in expression

MayilVahanan — Wed, 04 Jun 2014 05:32:41 GMT

Try like this

fabs(Sum(if([Transaction Type]='C' and Year=2014 and Month='May' and Match(Week,'18','19','20'),[Movement Quantity])))

But why you need to convert into if statement?

sujeetsingh — Wed, 04 Jun 2014 05:34:43 GMT

May be some comma or quotes missing.

OK bracket is missing at right

its_anandrjs — Wed, 04 Jun 2014 05:38:29 GMT

Try with this expression also

Fabs(Sum(if([Transaction Type]='C' and Year=2014 and Month='May' and Match(Week,18,19,20),[Movement Quantity]))

Wed, 04 Jun 2014 05:39:28 GMT

I am having the data for all weeks, But I want to display the data only for the weeks of May(18,19,20).

It means WTD analysis..

using above Expression i am getting the data for all weeks , i want to display only 18,19,20

MayilVahanan — Wed, 04 Jun 2014 05:41:36 GMT

Can you post a sample?

sujeetsingh — Wed, 04 Jun 2014 05:42:56 GMT

Using match is a good way to do so.

Wed, 04 Jun 2014 05:49:12 GMT

Hi Anand,

I am getting all the weeks of Data, and also that column data i am getting Zero.

its_anandrjs — Wed, 04 Jun 2014 07:11:12 GMT

Can you share some sample data.