topic Re: Variable Issue in QlikView

Variable Issue

Thu, 18 Aug 2016 15:37:43 GMT

I have table being loaded in to Qlikview app with a list of KPI numbers and description of the calculation.

With the following code

=MaxString({<Indicator_Number={1}>} Formula)

it will display the value num(sum([ED.4 Hour Non Breach Flag])/sum(ED.Count),'##.#%')

What I would like it to be able to do is to display the value of this calculation as a percentage (e.g. 92.4%) when I use it in a chart?

I also need this to be always showing as a value even if the Indicator_Number either has no selections on it or a selection other than "1" has been made..

Many thanks

Re: Variable Issue

vishsaggi — Thu, 18 Aug 2016 15:42:19 GMT

Can you share a sample app and expected output for this please ?

Re: Variable Issue

Thu, 18 Aug 2016 16:23:09 GMT

Attached is an example. I'd like the Using Variable chart to bring back the same result as the Using Formula Chart so that even when Indicator_number is either 2 or not selected then the % performance shows in the graph.

At the moment, I can only get the values to show in the chart when Indicator_Number = 1

Does that make sense?

Re: Variable Issue

vishsaggi — Thu, 18 Aug 2016 20:10:08 GMT

Can you explain what does this mean ?

"so that even when Indicator_number is either 2 or not selected then the % performance shows in the graph."

Re: Variable Issue

Fri, 19 Aug 2016 09:29:34 GMT

Ok - So I have gotten a little further with this but still having issues.

I need to be able to get the script below to show as a percentage value in a chart:

=$(MaxString({<Indicator_Number={1}>}Formula))

However, when the above script is put in to the expression definition, it comes out as '-'

In a text box, without the initial $( it shows as this:

num(sum([ED.4 Hour Non Breach Flag])/sum(ED.Count),'##.#%')

This is the text, but I want it to work as a calculation so that in a chart $(MaxString({<Indicator_Number={1}>}Formula)) returns as the following:

I feel like I am missing something. Any ideas? I would also add a new copy of the test QVW file, but there doesn't seem to be a "upload attachment option"

Re: Variable Issue

Fri, 19 Aug 2016 11:15:00 GMT

Ok - So I have gotten a little further with this but still having issues.

I need to be able to get the script below to show as a percentage value in a chart:

=$(MaxString({<Indicator_Number={1}>}Formula))

However, when the above script is put in to the expression definition, it comes out as '-'

In a text box, without the initial $( it shows as this:

num(sum([ED.4 Hour Non Breach Flag])/sum(ED.Count),'##.#%')

This is the text, but I want it to work as a calculation so that in a chart $(MaxString({<Indicator_Number={1}>}Formula)) returns as the following:

I feel like I am missing something. Any ideas? I would also add a new copy of the test QVW file, but there doesn't seem to be a "upload attachment option"

Re: Variable Issue

vishsaggi — Fri, 19 Aug 2016 13:52:20 GMT

I have to look into it bear with me. If you have a new attachment click on Use advance editor when you are in reply mode -> Use advance editor is located on top left corner of reply window, please attach the latest one if you have it.

Re: Variable Issue

Fri, 19 Aug 2016 13:57:42 GMT

Attached is a revised copy of the application

Re: Variable Issue

vishsaggi — Fri, 19 Aug 2016 14:21:35 GMT

Check this if this is what you looking for ?

Re: Variable Issue

tracysmart — Fri, 19 Aug 2016 14:33:14 GMT

Hi Rhiannon

you are just missing the equals in the expression.

=$(=MaxString({<Indicator_Number={1}>}Formula

Don't put the equals in the variable definition as this will evaluate outside of your chart and will not expand with the dimensionality of your chart.

Re: Variable Issue

Fri, 19 Aug 2016 14:36:55 GMT

Thanks Tracy,

I had a feeling it was something straightforward I was missing.

That works brilliantly...

Rhiannon

Re: Variable Issue

Fri, 19 Aug 2016 14:38:14 GMT

Hi Vish,

This did work for The KPI number 1 but wouldn't work for other KPI numbers. Tracy Smart found the answer though.

Thanks for looking in to this for me though..

Rhiannon

Re: Variable Issue

vishsaggi — Fri, 19 Aug 2016 15:16:37 GMT

I did not get you it works for me for both the number even when you dont select any in your Indicator number.

Below are the changes i did:

Variable: = MaxString({<Indicator_Number={1}>}Formula)

TextObject: $(MaxString)

In you Table Chart expr: $(MaxString)

Here MaxString is your variable name.

Re: Variable Issue

hirenjadiya — Fri, 19 Aug 2016 16:53:45 GMT

Hi Rhiannon,

Great that everything works out good for you,

Regards,

Hiren Jadiya