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
in Variable pass As follows:
vMonth 'Jan','Feb','Mar'
In Set
Sum({<Month={$(vMonth)}>}Sale)
Thanks,
Arvind Patil
Could you please share the set expression where you are thinking to use the said variable?
Regards!
Rahul Pawar
in Variable pass As follows:
vMonth 'Jan','Feb','Mar'
In Set
Sum({<Month={$(vMonth)}>}Sale)
Thanks,
Arvind Patil
did you try to replace variable with string value in set analysis ?
I have already tried above but it doesn't work , Error in expression
try using numbers for months, ex. 1 for jan, 2 for feb and so on...
Hello Andrea,
Below is the set expression :
sum({$<[Sales Month] = {$(vMonth)}>} Sales)
Below is the variable :
vMonth = 'Jan' ----This gives sum of sales for Jan
vmonth = 'Jan','Feb'
'Jan,Feb'; etc etc ----- I have tried various permutations and combinations with comma and semicolon but couldn't get sum of sales for both Jan and Feb
HI Arvind,
It shows error in expression but it works. else try below one:
Sum({<Month={'vMonth'}>}Sale)
Thanks,
Arvind Patil
let's try with the below:
sum( {$< [Sales Month] = {1,2} >} Sales )
Actually it gives 0 as output which is incorrect