Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Folks,
I'm using Alternate States with QS August 2022. Because I have charts that have combined measures, I find myself passing in the dimensions/years from the default state into my Set Analysis.
i.e
Sum({"State1"<Year=$::Year> + "State2"<Year$::Year> + $} Sales)
With each selection available to the user, the text between the brackets get longer and longer resulting in a monstrosity.
Sum({
"State1"<Year=$::Year,[Lactose Intolerance]=$::[Lactose Intolerance],[Horoscope]=$::[Horoscope]..> +
"State2"<Year$::Year,[Lactose Intolerance]=$::[Lactose Intolerance],[Horoscope]=$::[Horoscope]..> +
$} Sales)
Repeating each and every field that could be selected seems to have a code-smell and will lead to an insanely brittle dashboard.
Is there a way to pass all the non-listed fields to the alternate states?
Any help is greatly appreciated.
I typically address this kind of requirement using the set intersection operator "*". For example, "StateA" * $
See https://qlikviewcookbook.com/2016/07/alt-states-merged-selections-tip/ for more.
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com
I typically address this kind of requirement using the set intersection operator "*". For example, "StateA" * $
See https://qlikviewcookbook.com/2016/07/alt-states-merged-selections-tip/ for more.
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com