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: 
abdulaziz
Contributor III
Contributor III

Is possible to use alternate States with set analysis

Hello,

I try to create the new chart with use set analysis with alternate States !!!

I have this Expression

Sum( {1<TRANS_TYPE={"VOUCHER"} ,POST_DATE=  {"<=$(=Max(POST_DATE))"} >} (ITEM_QTY*VOU_n)*Cost_Item)

How I can add alternate States like Group1

Many Thanks

Abdulaziz

10 Replies
oknotsen
Master III
Master III

What you are trying to do in the above statement is mix up fields and values.

StatesA::{"VOUCHER"} effectively is asking for a value in StatesA, but you should either be asking for the value of a field OR a field of a state.


So either

SLIP_FLAG=StatesA::SLIP_FLAG

or

SLIP_FLAG={'0'}


May you live in interesting times!