topic Re: Variable in QlikView

Variable

carolin01 — Wed, 05 Mar 2014 14:27:01 GMT

Hello together,

I´ve a short question: In a chart I´m trying to let appear an expression conditionally:

= GetSelectedCount ({$(vChooseYear1)}) = {$(vCurrentFY)}

I would like to show the expression only if the Variable vChooseYear1 is equal to the Variable vCurrentFY.

I´m still strugling to understand when it has to be done how. Could anybody help me to correct this function?

Many thanks for your help!

Best regards,

Carolin

Re: Variable

gandalfgray — Wed, 05 Mar 2014 14:30:57 GMT

I think you can just use:

Variable1=Variable2

works for me, at least

Re: Variable

nilesh_gangurde — Wed, 05 Mar 2014 14:32:41 GMT

Try this.

if(GetSelectedCount ('$(vChooseYear1)' = '$(vCurrentFY)') = 1,1,0)

-Nilesh

Re: Variable

Wed, 05 Mar 2014 14:57:34 GMT

Hi Carolin:

this should really work: (i do not use any quotes)

=GetSelectedCount($(vChooseYear1))=$(vCurrentFY)

(and no if() as it is in a "show conditional" - expression)

Re: Variable

Wed, 05 Mar 2014 15:07:40 GMT

Enable the condition check box..

Re: Variable

gandalfgray — Wed, 05 Mar 2014 15:09:13 GMT

I don't see why you should use GetSelectedCount to compare two variables?

If vChooseYear and vCurrentFY is two variables as Carolin states, a simple comparison like I suggested will do.

Regards/GG

Re: Variable

carolin01 — Wed, 05 Mar 2014 15:11:56 GMT

This worked, too - thank you 🙂

Re: Variable

carolin01 — Wed, 05 Mar 2014 15:12:22 GMT

Thank you, this worked. 🙂

Re: Variable

Wed, 05 Mar 2014 15:21:28 GMT

Hi GG,

I assume in vChooseYear is the fieldname (Year?). And in vCurrentFY is the number of selected items of this field.

May be (for example) she wants to show a specific chart only when NumberOfSelectedYears = 1.

HtH

Roland

Re: Variable

carolin01 — Wed, 05 Mar 2014 15:47:04 GMT

Hi,

the reason why I was trying to do this is that we have created a sales plan for the current fiscal year. This is shown in a chart where you can choose two different years and compare them. Therefore I created two variables:

vChooseYear1 and vChooseYear2. As we have created the sales plan only for the current fiscal year it does not make sense to show it if you compare 2012 against 2013. Therefore I wanted to show the expression to show the sales plan only if the variable vChooseYear1 = vCurrentFY (=current fiscal year).

I appreciate very much the quick help of you both. Both solutions are working here 🙂

Best regards

Carolin

Re: Variable

gandalfgray — Thu, 06 Mar 2014 09:08:02 GMT

O, I see what you mean now.

vCurrentFY is a very confusing name in that case (at least for me... ), with that name I am expecting it to contain 2012, 2013, 2014 or similar values.

And I also thought vChooseYear would contain a value like 2011, 2012 etc.

And then you wanted to show the expression column if these two were equal.

/gg