Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem in Expression.

Hi,Can anyone pls suggest why my below expression is wrong:

sum( if(ACCT='QOP.C' or 'MHOODC' ,{<status={Current}>} Sold_At*Qty*CONV_RATE,
{<status={Current}>} Sold_At*Qty))

Thanks,

Swetha

1 Solution

Accepted Solutions
fernando_tonial
Employee
Employee

You can try:


sum({<status={'Current'}>} if(ACCT='QOP.C' or ACCT='MHOODC' , Sold_At*Qty*CONV_RATE,
Sold_At*Qty))


Don't Worry, be Qlik.

View solution in original post

3 Replies
Not applicable
Author

I got it,Thanks!

fernando_tonial
Employee
Employee

You can try:


sum({<status={'Current'}>} if(ACCT='QOP.C' or ACCT='MHOODC' , Sold_At*Qty*CONV_RATE,
Sold_At*Qty))


Don't Worry, be Qlik.
Not applicable
Author

Yep Yep tried the same and got it.Thanks!