topic Re: Question about variables in QlikView

Question about variables

Teppo_Ojala — Sat, 11 Jun 2011 06:16:21 GMT

Hi,

Does anyone know if this is possible or not in QV.

Can I call a variable with parameter-information?

One example: I have 5 KPI's and I have an expression, which has for example little bit set analysis and some other logic. In the set analysis I tell which KPI I am looking for, for example KPI={'5'}

I can of course write 5 varibles, one per each KPI - but my question is: can I write only one variable and then use KPI as paramter when calling the variable.

This example is not a real one. I just have thought that this would be very useful in some cases.

Thanks!!

Question about variables

Sat, 11 Jun 2011 07:54:24 GMT

I use this trick very often in data analysis.

1) Create a variable KPI (Setting > Variable Overview)
2) Create an input box with the variable KPI

Then go to Constraints panel > Predifined Values

Check Listed Value

Example : check KPI1,KPI2, KPI3, KPI4, KPI5

3) Create a chart using generic formula :

Sum( $(KPI) )

Hope it helps you

Question about variables

Teppo_Ojala — Sat, 11 Jun 2011 09:57:59 GMT

Thanks, this is a useful tip too, but I am sorry this doesn't help me in this case. Or atleast I think so

My idea is (again for example) to have these KPI's listed same time in the sheet. I think you can't have 5 charts next to each other using one variable and showing 5 different KPI's with this inout field logic? If variables would be like finctions, this would be possible to do. Just by calling a variable like this =$(v_kpi_value(KPI1))

But this is nor possbile and I don't find out a work around for this. What do you think, would this be a good enhance request for new QV versions? I think I could find out use cases for this.

Re: Question about variables

Sat, 11 Jun 2011 14:50:33 GMT

Toa,

Variable with parameter is possible. I could able to make it work with simple if statemen but not bale to do it with set analysis.

Check out out this application. hope this helps you.

- Sridhar

Question about variables

mike_garcia — Sat, 11 Jun 2011 22:54:25 GMT

Yes, the solution provided by Sridhar is the way to do it... If you require more information about it, look for 'Dollar-Sign Expansion with Parameters' in the QlikView help.

Mike.

Re: Question about variables

Teppo_Ojala — Sun, 12 Jun 2011 04:11:42 GMT

Great,

Exactly the solution that I am looking for. Thanks for quick help!!

I managed to get Set analysis working with formula:

sum({<KPI_trans = {'$1'}>} Amt)

Teppo

Re: Question about variables

Teppo_Ojala — Sun, 12 Jun 2011 19:20:39 GMT

One more thing. Any ideas why the textbox with two variable calls doesn't work. I tried to call the variable twice in one text box, but I can't get two sums as a result to this object. You can find this problem from attached qvw.

This is a minor problem, but I am just curious..

Thanks again,

Teppo

Re: Question about variables

Mon, 13 Jun 2011 01:20:26 GMT

Teppo,

I managed to take the second set to next line, it started displaying the value. But no idea why the same is not working with single line .

Have a look at the application.

- Sridhar