Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
As always, Please go thru CookBook Site for basic concepts, Please
sum({< Year_V={2018} , Status_V={'Open'} >} Amt_$K)
As always, Please go thru CookBook Site for basic concepts, Please
sum({< Year_V={2018} , Status_V={'Open'} >} Amt_$K)
Thank you very much
Hi Anil
Where is the link for the cookbook ?
Paul
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
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>
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>