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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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)