topic Re: Caculated variable not showing in chart... in QlikView

Caculated variable not showing in chart...

Mon, 30 Mar 2015 13:10:28 GMT

The following will work in a textbox:

=$(='v'&'KPI_01_01_RAG')

And this will work in a chart expression:

='v' &

[KPI_Details] & '_RAG'

However,

=$(='v'& [KPI_Details] & '_RAG'

in a chart expression doesn't work.

Any ideas?

Stewart

Re: Caculated variable not showing in chart...

sunny_talwar — Mon, 30 Mar 2015 15:28:22 GMT

What are you trying to achieve?

Best,

Sunny

Re: Caculated variable not showing in chart...

Anonymous — Mon, 30 Mar 2015 15:28:48 GMT

Do you need a closing bracket ?

You've got =$(='v'............ but no closing bracket.

Re: Caculated variable not showing in chart...

Mon, 30 Mar 2015 15:49:00 GMT

Hi Sunindia

I am generating KPIs and one value that I need is contained in a series of variables.

Using the KPI_Details chart dimension, I was hoping to concatenate it with some text to get the correct values.

I have the variable names - but now need their values......

Ideas?

Stewart

Re: Caculated variable not showing in chart...

Tue, 31 Mar 2015 09:34:18 GMT

Just a typo - still got the same problem with closing bracket....

Re: Caculated variable not showing in chart...

rubenmarin — Tue, 31 Mar 2015 09:40:48 GMT

Hi stewart, I think is because $-expanded variables are expanded before calculate the chart, not row by row, so they don't have the row value.

If you add in a chart with only one [KPI_Details] value selected, it works?

Re: Caculated variable not showing in chart...

Tue, 31 Mar 2015 09:51:15 GMT

Hi Ruben

You may be onto something - as this does work in a textbox. Single Value [KPI_Details] works without any problem.

I now have a very useful variable that I cannot get into table (with some pretty sparklelines)...... any ideas?

Stewart

Re: Caculated variable not showing in chart...

rubenmarin — Tue, 31 Mar 2015 09:58:26 GMT

Probably you wouldn't like my next answer: when I did something similiar (also with pretty sparklines and gauge indicators), I made different tables, one for each KPI and each using his own variable, no dependant of dimension value.

Hope some other user give us a better option.

Re: Caculated variable not showing in chart...

Tue, 31 Mar 2015 10:16:29 GMT

Hi Ruben

Not the answer I wanted to hear - but it does give me a way forward and stops me from hitting my head on the Qlikview Brickwork....

I will be interested to see if other users have a different approach.....

Thanks

Stewart

Re: Caculated variable not showing in chart...

Peter_Cammaert — Tue, 31 Mar 2015 10:35:17 GMT

Keep the variables but build a big if-then-else in your expression field. All substitutions will happen before recalculating the chart, and by extension the different KPI formula's will fall into the right spots.

Once you got that working, you can consider filling a new variable with the big if-then-else in your script, based on a KPI definition table. A loop will take care of any casual additions/omissins, or will handle the KPI-spec in an external file (for example in an Excel).

Best,

Peter

Re: Caculated variable not showing in chart...

Tue, 31 Mar 2015 10:40:46 GMT

Simple and easy way forward. Excellent

Unfortunately, I an using resursion in a chart to generate the KPI indicators which will be a massive pain to replicate in the script.

Thanks for the help guys.

Stewart

PS My first time on forum - can two answers be correct?

Re: Caculated variable not showing in chart...

Peter_Cammaert — Tue, 31 Mar 2015 10:50:45 GMT

No they can't.

Pick whatever you like the most, you can always change the assignment later on. Or assign a Correct and a Helpful answer. People shouldn't focus that much on rewards anyway... It's the glory of providing good feedback that counts

Re: Caculated variable not showing in chart...

Tue, 31 Mar 2015 10:55:19 GMT

OK.

Looks like i'm in a chilled forum. Sounds good to me.

Thanks all