topic Re: multiple varible inside set analysis in QlikView

multiple varible inside set analysis

Anonymous — Wed, 19 Aug 2015 07:06:46 GMT

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

Re: multiple varible inside set analysis

Anonymous — Wed, 19 Aug 2015 07:09:07 GMT

please post your Expression with set analysis

Re: multiple varible inside set analysis

jonathandienst — Wed, 19 Aug 2015 07:10:53 GMT

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

Re: multiple varible inside set analysis

Wed, 19 Aug 2015 07:14:48 GMT

Can you please post your expression and variables?

Re: multiple varible inside set analysis

Anonymous — Wed, 19 Aug 2015 07:34:57 GMT

=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

Re: multiple varible inside set analysis

gautik92 — Wed, 19 Aug 2015 07:39:04 GMT

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

Re: multiple varible inside set analysis

Anonymous — Wed, 19 Aug 2015 07:43:46 GMT

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

Re: multiple varible inside set analysis

Anonymous — Wed, 19 Aug 2015 09:09:06 GMT

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

Re: multiple varible inside set analysis

qlikmsg4u — Wed, 19 Aug 2015 09:11:57 GMT

Change Variables for year and month

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

Re: multiple varible inside set analysis

Anonymous — Wed, 19 Aug 2015 09:20:48 GMT

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())

Re: multiple varible inside set analysis

qlikmsg4u — Wed, 19 Aug 2015 09:25:25 GMT

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

Re: multiple varible inside set analysis

gautik92 — Wed, 19 Aug 2015 09:29:04 GMT

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

Re: multiple varible inside set analysis

Anonymous — Wed, 19 Aug 2015 10:04:17 GMT

ya correct, but it does not work

Re: multiple varible inside set analysis

qlikmsg4u — Wed, 19 Aug 2015 10:08:34 GMT

is it ok to post the sample app?

Re: multiple varible inside set analysis

Alvaro_Palacios — Wed, 19 Aug 2015 10:16:05 GMT

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.

Re: multiple varible inside set analysis

Anonymous — Wed, 19 Aug 2015 10:19:29 GMT

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

Re: multiple varible inside set analysis

Anonymous — Wed, 19 Aug 2015 10:27:17 GMT

Ya it is with equal only

Re: multiple varible inside set analysis

Anonymous — Wed, 19 Aug 2015 10:27:42 GMT

hi neetha, thanks tried same already but doesnt work

Re: multiple varible inside set analysis

Anonymous — Wed, 19 Aug 2015 10:29:47 GMT

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

Re: multiple varible inside set analysis

qlikmsg4u — Wed, 19 Aug 2015 10:32:35 GMT

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)