Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

arvind_patil
Valued Contributor II

Re: Creating variables

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

Thanks,

Arvind Patil

arvindjha2050
New Contributor II

Re: Creating variables

Hello Andrea,

The above dint work.

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

arvindjha2050
New Contributor II

Re: Creating variables

Yes it's correct

vMonth =  'Jan','Feb'

agigliotti
Honored Contributor II

Re: Creating variables

else try:

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


the same using variable:

vMonth =  'Jan','Feb'


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

arvindjha2050
New Contributor II

Re: Creating variables

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
New Contributor II

Re: Creating variables

Thanks a lot it worked

arvindjha2050
New Contributor II

Re: Creating variables

Thanks a lot it worked

Highlighted
sasiparupudi1
Honored Contributor III

Re: Creating variables

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