Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want a certain expression to be used only if the current month in included in the selections. Currently i have this expression in the Conditional "Show" Field of the Expression. However, it only works if only the current month is selected, not if the current month is among the selections.
[Month]=Vcmth and [Fiscal Year]=Vcyr
i'm using Qlikview 11.
Hi
Are you expect like this, for ex: if sep month is among selection, then expression want to show? if so, try like this
=WildMatch(GetFieldSelections(Monthyear,','),'*Sep*') it returns 1 if sep month is in selections else return 0.
Thank you for your reply, this doesn't seem to be working for me. The expression is only showing when Sep is the only month selected.