topic Re: variable ? in QlikView

variable ?

Wed, 18 Jul 2012 14:49:46 GMT

Hi All,

Can anybody tell me how to use more than one variable in set expression?

I have a variable => Vperiod -> =getfieldselection(PERIOD)

And I want to use it in expression while they are more than one period in Vperiod : (1,2,3,4,5,6,7,...)

expression is =sum ( {$(=PERIOD=??????

Thanks

Re: variable ?

cesaraccardi — Wed, 18 Jul 2012 14:57:53 GMT

Hi,

You can use like this: sum({$<PERIOD={$(Vperiod)}>} Values)

Regards,

Cesar

Re: variable ?

Wed, 18 Jul 2012 15:00:25 GMT

Thanks for reply,

It's good when you have one variable but withmore than one not working...

like 1,2,3,4,...

Any more idea?

Re: variable ?

cesaraccardi — Wed, 18 Jul 2012 15:02:44 GMT

I dont know if I understand... You have one variable with multiple values or more than one variable with multiple values?

Re: variable ?

Wed, 18 Jul 2012 15:07:45 GMT

Here is the case:

I have period you which might be a single selection or multiple seceltion.

so if I select ie: period 1 , my getfiledselection returns 1 and in the set analysis it works, but if I select 1 & 2 in getfieldselection it returns 1,2 and in set analysis it goes crazy because it does not work with 1,2 .

Is it clear?

Thanks

Re: variable ?

cesaraccardi — Wed, 18 Jul 2012 15:12:14 GMT

Ok... please notice that I put the variable inside the set without the ' around it. And this works if you define your variable with =GetFieldSelections(Period) otherwise the entire set of values will be treated as a single value and the expression wont work.

Re: variable ?

MayilVahanan — Wed, 18 Jul 2012 15:14:46 GMT

Check this,

Edit:

Cesar Accardi Jr suggestion work.. Sorry Cesar Accardi Jr, i didn't see your post..

Hope it helps

Re: variable ?

cesaraccardi — Wed, 18 Jul 2012 15:16:13 GMT

Yes, thats exaclty what I suggested... using the variable without '

Edit: No problem, Mayil.

Re: variable ?

Wed, 18 Jul 2012 15:40:52 GMT

Thanks Cesar,

Can you please tell me how to add "only" to this function?

Re: variable ?

cesaraccardi — Wed, 18 Jul 2012 16:25:26 GMT

Sure, using the function only:

sum({$<PERIOD={'$(=Only(Period))'}>} Values)

Note that this function will works if you have only 1 possible value for Period.