Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

If stmt ?

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

10 Replies
sujeetsingh
Master III
Master III

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


Hope it helps

Not applicable
Author

Hi sujeet,

it was showing error in expression

MayilVahanan

Hi

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?

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
sujeetsingh
Master III
Master III

May be some comma or quotes missing.

OK bracket is missing at right

its_anandrjs

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]))

Not applicable
Author

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

Hi

Can you post a sample?

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
sujeetsingh
Master III
Master III

Using match is a good way to do so.

Not applicable
Author

Hi Anand,

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