Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a problem with qlikview.
I have a calendar that I can select multiple values for month. I need to know if when I have selected several months March is selected.
For example:
If ('March' IN selected-months, then condition)
I tried with Match function but this only works if you select only one month.
Any ideas?
Thanks!
Michael is right concat and getfieldselections are similar but no the same, the reason I prefer to use concat over getselections is because I can massage the values to the format want, so if I am looking for a result called Inventory, but in my selections I have Inventory and Warehouse inventory I can still separate them
"and GetSelectedCount(Month) > 0" this part of the expression makes sure that this only works when this field is selected, otherwise the concat will bring you all the values