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: 
paulyeo11
Master
Master

How to add one more condition expression ?

Hi All


Below is the expression work fine :-

sum(Amt_$K)


I need to add 2 more below condition :-


Year_V=2018


Status_V=Open


I try :-


sum(if(Year_V=2018,(Amt_$K)))


it work fine , then i add one more condition :-


sum(if(Year_V=2018, Status_V="Open",(Amt_$K)))


it return not correct value.


Paul

1 Solution

Accepted Solutions
Anil_Babu_Samineni

As always, Please go thru CookBook Site for basic concepts, Please

sum({< Year_V={2018} , Status_V={'Open'} >} Amt_$K)


Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

6 Replies
Anil_Babu_Samineni

As always, Please go thru CookBook Site for basic concepts, Please

sum({< Year_V={2018} , Status_V={'Open'} >} Amt_$K)


Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
paulyeo11
Master
Master
Author

Thank you very much

paulyeo11
Master
Master
Author

Hi Anil

Where is the link for the cookbook ?

Paul

Anil_Babu_Samineni

This one is the best about World Qlikview. Qlikview Cookbook | Recipes for Qlikview Success

If you look help we will get all things club together Set analysis and set expressions ‒ Qlik Sense

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
paulyeo11
Master
Master
Author

Hi Anil

Thank you for the link , I will refer to the link in future .

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

paulyeo11
Master
Master
Author

Hi Anil

I have check thru the cook book and link on SET , which part of the 2 link it does explain about how to solve my problem ?

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>