Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Alternate States - keep everything BUT certain selections synchronised

Let's say I have a couple of standard selection in my app like Produkt, Sales Person, Office and Year.

I want to create an alternate state and set expression that only affects the year while keeping everything else synchronised. I already saw in the documentation that you can manually choose which fields to keep that way like so:

count({State1<Year = $::Year, Month = $::Month>} DISTINCT [Invoice Number])


Now is it possible to the "inverse" and just select certain fields from the alternate state and keep everything else synchronised?

Labels (1)
1 Reply
Contributor III
Contributor III

Update: I've found it.
It works like so:
sum({$<JahrPeriode = Muster::JahrPeriode, MonatPeriode = Muster::MonatPeriode>} [CE11000.MusterFlag])

Now only these two fields are affected