Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
bert_geraerts
Contributor II
Contributor II

Problem using set analysis with alternate states

Hi,

I use the following expression to calculate all incomming pallets that we received before the selected date.


=sum({$<%Date = {"<$(=min({$} %Date))"}, Year=, Quarter=, Month=, Week= >}IN)

This is working perfectly, but now want to integrate this graph into a different report and therefore I have to use an alternate state.

But after this the formula doesn't seem to work anymore.  Who can tell me what I'm doing wrong?

My new formule after alternate state (=StateB) :

=sum({StateB<%Date = {"<StateB(=min({StateB} %Date))"}, Year=, Quarter=, Month=, Week= >}IN)


My result is always 0.

1 Solution

Accepted Solutions
sunny_talwar

Try this

=Sum({StateB<%Date = {"<$(=Min({StateB} %Date))"}, Year=, Quarter=, Month=, Week= >}IN)

View solution in original post

1 Reply
sunny_talwar

Try this

=Sum({StateB<%Date = {"<$(=Min({StateB} %Date))"}, Year=, Quarter=, Month=, Week= >}IN)