Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
arvindjha2050
Creator
Creator

Creating variables

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

17 Replies
arvind_patil
Partner - Specialist III
Partner - Specialist III

kindly check your month field names are in properly given in variable.

Thanks,

Arvind Patil

arvindjha2050
Creator
Creator
Author

Hello Andrea,

The above dint work.

How will expression evaluate 1 as Jan and 2 as Feb?

arvindjha2050
Creator
Creator
Author

Yes it's correct

vMonth =  'Jan','Feb'

agigliotti
Partner - Champion
Partner - Champion

else try:

sum( {$< [Sales Month] = {'Jan','Feb'} >} Sales )


the same using variable:

vMonth =  'Jan','Feb'


sum( {$< [Sales Month] = {$(vMonth)} >} Sales )

arvindjha2050
Creator
Creator
Author

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

arvindjha2050
Creator
Creator
Author

Thanks a lot it worked

arvindjha2050
Creator
Creator
Author

Thanks a lot it worked

sasiparupudi1
Master III
Master III

Please close this thread by marking any helpful and a correct answer so that this may be helpful for others