one click graph change

[#1]

i have 10 different graphs with  values

but i want to turn them into percentage

i duplicated the graphs and used selection value/graph

but maintanence is difficult when i wanted a changement

so i want to use grouping of value/percentage in a graph

and i want a button and when i click this all graphs will turn to percentage

(on the other hand i hva eto click 10 times to change grouping)

Do you have any idea to solve this problem

thanks

[MayilVahanan]

Hi,

     I think if i understand your requirement like this, you have 20 graphs.. 10 for values and 10 for percentage..

if a button click means, all 10 chart will hide and another 10 graph want to appear.. am i right? if so,

Try this,

in all 10 values chart, properties -> layout -> conditional -> give like"= vhide = 0"

in all 10 percentage chart, properties -> layout -> conditional -> give like "=vhide =1"

in button give Variable name like vhide..

and in values give if(vhide =0 , 1, 0)

hope it helps

    

[#3]

If you are using QV 11 the following would be helpful.

Assuming the expresison is Exp:

1. Num(Exp,'#,##0')
2. Num(Exp,'#,##0.0 %')

For the first expression add conditional display like if(vExpType = 'Value' ,1,0) and viceversa for the second.

Add a inputbox for vExpType variable with constaints to get values from dropdown.

Kiran.

[#4]

Hi Mayil, Hi Kiran Thanks very much

Kiran your solution is correct but now i use qlikview 10.

Mayil i use your solution now but i want another solution. İ have 10 graphs. in graphs i have two expressions that i have grouped. you know in grouping when you click arrow it turns other expression.

but for ten graphs i have to click ten times

but i want the way when i click one button i want the changement.

note: i dont have 20 graphs

[#5 · Accepted solution]

Hi,

The logic is same if you are using straight table just apply the condition presentation table.

Option2 for QV10:

1. Create a variable vNumFormat (and vExpType as in above example)
2. vNumFormat = if(vExpType = 'Value' ,'#,##0','#,##0.0 %')
3. Change the expression in chart to Num(Exp,$(vExpType))
4. Change the number format to expression default

Kiran Rokkam.

[#6]

thanks a lot