Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is it possible to have 3 tables fixed on 3 different alternative states and filter all of them by dates at the same time (with the same data picker) ?
Thanks,
Domm
Yes you can. A set expression can refer to a field in another state using the syntax:
statename::field
For example:
Sum({<Year=$::Year>}Sales)
will use the Year value(s) from the default state regardless of what state the current object is in.
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com
No.
Not with alternate state, each object could only be associated to one alternate state.
If u want to achieve such a thing, u should use set expressions.
Thanks, so do I have to create different measures like that one
sum({< {Market] = {'DE'}, [Observation] = {">=$(=min([CalendarDate_Observation]))<=$(=max([CalendarDate_Observation]))"} >} Revenue) ?
Or there is another way to fix it?
Yes you can. A set expression can refer to a field in another state using the syntax:
statename::field
For example:
Sum({<Year=$::Year>}Sales)
will use the Year value(s) from the default state regardless of what state the current object is in.
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com
Finally; someone explained the meaning of the $:: syntax !
Thanks !!
Thanks for your answer.
I tried to do it, but I doesn't work. I don't why QlikSense doesn't know my state
I created it from "Alternative states" --> "Create new"
How can I fix this problem?
Please re-read Rob's answer.
That's not what he meant...
You have State1 and want ur chart to still be modified when u filter with a date field (not related to the state)
u do:
sum({<date=$::date>}measure)
Thanks, now it works. I was confused about statename::field.
Thanks 🙂
Hi,
your solution works for sum({< Observation= $::CalendarDate_Observation>} Revenue)
I also have to calculate the Monthly Goal like
You can use set expressions inside any aggregation function. So use it in the max function as well.
-Rob