Set Analysis COndition with ALternate State & Default State Condition

ext_bks — Sat, 16 Nov 2024 06:16:46 GMT

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!

Re: Set Analysis COndition with ALternate State & Default State Condition

Oleg_Troyansky — Tue, 26 Mar 2019 17:47:32 GMT

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

topic Set Analysis COndition with ALternate State & Default State Condition in App Development

Set Analysis COndition with ALternate State & Default State Condition

Re: Set Analysis COndition with ALternate State & Default State Condition