Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
ext_bks
Employee
Employee

Set Analysis COndition with ALternate State & Default State Condition

Hi All,

I currently have a chart with this measure:

Sum({<[Task Resource.rsrc_type]={'RT_Labor'}>} (act_reg_qty)*[Task Resource.cost_per_qty])

 

I would like to incorporate alternate state AND allow it to inherit default state selections too, something like:

{"State1"<proj_short_name = $::proj_short_name>} ,  {"State1"<proj_status = $::status>} and {"State1"<resource = $::resource>}

 

I'm having troubles incorporating them. Any help is appreciated!

1 Reply
Oleg_Troyansky

Hi,

 

It looks like you got tangled in the Set Analysis syntax. Make sure you have all of your conditions listed in one comma-separated list. Keywords like "and" are not accepted there. You don't need double quotes for your Alt State code, either.

For quoting possible values from another Alternate State, I'd recommend using the function P(). So, something like this should fly:

{State1<

Project  = P({$} Project), Status = P({$} Status), resource=P({$} Resource)

>}

It's not too late to sign up for the next Masters Summit for Qlik event in Stockholm, starting on Monday,  where I'm teaching advanced Set Analysis, AGGR, and Alternate States. 

Cheers,

Oleg Troyansky