multiple varible inside set analysis

[Anonymous]

Can we pass multiple variable inside set analysis? i am passing 4 variables, but does not work

[qlikmsg4u]

the expression you posted is incorrect because

in your variable vPrevmnth1=month(AddMonths(Today(),-1)) you will get month, how can you comapre year field with month?

Year={'$(vPrevmnth1)'}

so it should be Year={'$(vPrevmnth2)'}

and same for Month also

[gautik92]

avg({$<Environment={'$(vEnvironment)'},Component={'$(vComponent)'},Year={"$yearstart(vPrevmnth1)"},Month={"$WeekStart(vPrevmnth2)"}>} usage)

[Anonymous]

ya correct, but it does not work

[qlikmsg4u]

is it ok to post the sample app?

[Alvaro_Palacios]

Hey Rajashmita,

When creating these two variables

vPrevmnth1

vPrevmnth2

make sure you add the equal sign '=' before the expressions so these are evaluated and can be correctly passed to the set analysis expression:

=month(AddMonths(Today(),-1))

=year(Today())

Alvaro P.

[Anonymous]

Hi Rajashmita,

Try as below

=avg({$<Environment={'$(vEnvironment)'},Component={'$(vComponent)'},Year={'$(vPrevmnth1)'},Month={'$(vPrevmnth2)'}>} usage)

where vPrevmnth1 = year(Today())
vPrevmnth2 = month(AddMonths(Today(),-1))

Regards

Neetha

[Anonymous]

Ya it is with equal only

[Anonymous]

hi neetha, thanks tried same already but doesnt work

[Anonymous]

ll try to upload the sample, but just wanted to tel that month(AddMonths(Today(),-1)) gives Jul as data and with above expression it does not show anything, and dimention as week,data,hour and minute

[qlikmsg4u]

what is your month format?

try to give static values in set expression rather than variable values and see what happens.

avg({$<Environment={'$(vEnvironment)'},Component={'$(vComponent)'},Year={2015},Month={7}>} usage)