Variable Issue

[#1]

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

[#2]

Thanks Tracy,

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

That works brilliantly...

Rhiannon

[#3]

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

[vishsaggi]

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.

[hirenjadiya]

Hi Rhiannon,

Great that everything works out good for you,

Regards,

Hiren Jadiya