Set Analysis with Alternate State - ignore specific field selections

Philip_Z — Tue, 20 Dec 2022 17:02:42 GMT

Hi everyone,

I found topics on how to exclude field selections in a set analysis. However I am using a formula including an alternate state where the solutions I found don't seem to work.
I am using Qlik Sense SAAS.

I want to include any selections for fields not specified and exclude selections only for specific fields. I am also using the set expression to fix some selections.

My formula goes like this:

Sum({$*[Current Timeframe]<serviceStatus_leistung-={'SE','ST'},price_leistung={">0"},dataSource_leistung={'Online'},Area=>}price_leistung)

This Formula sums the price for all services in the given State which don't match the specified Status, have a price above 0 and only for data which has the source = Online.
I want to exclude selections of the Field "Area" since this would overwrite my datasource selection, ans in many cases resulting in 0 values. With my current formula however, if I make any selections for the field "Area", the value drops to 0 regardless of my exclusion attempt of said field by setting "Area= "
The Selection Field "Area" is not fixed to the State [Current Timeframe] since it should apply on all states in the dashboard (I am using states to display multiple timeframes). Could this be the issue? Do I have to specify in my formula that this field is not fixed to the alternate state?
All other Fields which are used for selections are also not fixed to the State and they should apply to my selection (this is working with the current formula).

If I don't use any identifier and operator like this, no selections from other fields get applied:
Sum({[Current Timeframe]<serviceStatus_leistung-={'SE','ST'},price_leistung={">0"},dataSource_leistung={'Online'},Area=>}price_leistung)

I also tried it with the P( Function as described in other solutions which had the same result.

Thanks for any help
Philip

topic Set Analysis with Alternate State - ignore specific field selections in App Development

Set Analysis with Alternate State - ignore specific field selections