topic Re: How to add one more condition expression ? in QlikView

How to add one more condition expression ?

paulyeo11 — Sun, 04 Feb 2018 01:32:59 GMT

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 — Sun, 04 Feb 2018 01:35:12 GMT

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

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

paulyeo11 — Sun, 04 Feb 2018 01:37:19 GMT

Thank you very much

paulyeo11 — Sun, 04 Feb 2018 01:44:32 GMT

Hi Anil

Where is the link for the cookbook ?

Paul

Anil_Babu_Samineni — Sun, 04 Feb 2018 01:47:46 GMT

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

paulyeo11 — Sun, 04 Feb 2018 02:02:11 GMT

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 — Sun, 04 Feb 2018 22:35:15 GMT

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