Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Team,
I am trying to create variable in Qliksense with multiple values but it's not working for which i tried various combinations.
While creating a variable say with expression : 'January' -----This works
But when i want multiple values it doesn't work : 'January;February' -----This doesn't work
How to correctly define them such that they can be used in set expressions?
Thanks & Regards,
Arvind Kumar Jha
kindly check your month field names are in properly given in variable.
Thanks,
Arvind Patil
Hello Andrea,
The above dint work.
How will expression evaluate 1 as Jan and 2 as Feb?
Yes it's correct
vMonth = 'Jan','Feb'
else try:
sum( {$< [Sales Month] = {'Jan','Feb'} >} Sales )
the same using variable:
vMonth = 'Jan','Feb'
sum( {$< [Sales Month] = {$(vMonth)} >} Sales )
sum( {$< [Sales Month] = {"Jan","Feb"} >} Sales ) ----This works and known to me , i wanted to do it through variable for recurrent use
But the variable part doesn't work , have tried many options
Thanks a lot it worked
Thanks a lot it worked
Please close this thread by marking any helpful and a correct answer so that this may be helpful for others