topic one click graph change in QlikView

one click graph change

Thu, 12 Jul 2012 14:44:33 GMT

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

Re: one click graph change

MayilVahanan — Thu, 12 Jul 2012 15:01:18 GMT

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

Re: one click graph change

Thu, 12 Jul 2012 16:52:40 GMT

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

Assuming the expresison is Exp:

Num(Exp,'#,##0')
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.

Re: one click graph change

Fri, 13 Jul 2012 08:47:55 GMT

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

Re: one click graph change

Fri, 13 Jul 2012 08:54:28 GMT

Hi,

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

Option2 for QV10:

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

Kiran Rokkam.

Re: one click graph change

Fri, 13 Jul 2012 09:45:37 GMT

thanks a lot