multiple varible inside set analysis

[Anonymous]

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

[Anonymous]

please post your Expression with set analysis

[jonathandienst]

You may get a response if you provide more information and, if possible a sample qvw file illustrating your problem. I do not know what you mean by "pass multiple variable".

Qlik Community Tip: Posting Successful Discussion Threads

[#4]

Can you please post your expression and variables?

[Anonymous]

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

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

i wanted to display previous month data also for previous week so passing variable

[gautik92]

You can pass multiple variables inside set analysis if you can post your exprssion it will be more clear for others to help you

[Anonymous]

Here is my expression:

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

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

i wanted to display previous month data also for previous week so passing variable

[Anonymous]

Guys  i have posted the expression, i want to display previous month data and previous week data in the chart

[qlikmsg4u]

Change Variables for year and month

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

[Anonymous]

Below is not correct?i want to display for previous month data in chart having dimention in drill down week,date,hour,minute. so it should display previous month weeks as dimention.

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

vPrevmnth2=year(Today())