How to add one more condition expression ?

[paulyeo11]

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

[Anil_Babu_Samineni · Accepted solution]

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

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

[paulyeo11]

Thank you very much

[paulyeo11]

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

[paulyeo11]

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]

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>