topic Re: Toggle views in a chart in QlikView

Toggle views in a chart

Mon, 22 Sep 2014 06:48:49 GMT

Good Morning from Germany,

I have a question abou how to toggle the view in a chart from absolute values to procentage?

Example: the two (2) waterfall graphs showing the Revenue to margin development one in absolute fiagures the other as procentage.

How to have one graph and switch in the grapgh from one view to the other?

Thanks for your help, Matthias

Re: Toggle views in a chart

sujeetsingh — Mon, 22 Sep 2014 06:50:17 GMT

You can use bar offset

Re: Toggle views in a chart

amit_saini — Mon, 22 Sep 2014 06:52:36 GMT

Matthias,

This may help you:

Toggle between percentage and numbers on a chart

Re: Views in Charts

Thanks,

Re: Toggle views in a chart

sushil353 — Mon, 22 Sep 2014 06:54:04 GMT

Hi,

You can create a button to switch between two views.

create a variable say vSwitch and assign a value 0 to it.

now create a button and set action as set variable.. not(vSwitch)

now in your chart expression if($(vSwitch)=0, sum(values),count(values))

HTH

sushil

Re: Toggle views in a chart

ashfaq_haseeb — Mon, 22 Sep 2014 06:57:19 GMT

Like this

Regards

ASHFAQ

Re: Toggle views in a chart

jagan — Mon, 22 Sep 2014 06:57:22 GMT

Hi,

Create two expressions

Exp1: Actual

Sum(Sales)

Exp2: %

Sum(Sales)/Sum(TOTAL Sales)

Now Click on second expression, and click on the Group button in

Chart Properties -> Expression tab

Now the icon is created on the chart by click that icon you can toggle the expressions.

Hope this helps you.

Regards,

Jagan.

Re: Toggle views in a chart

ashfaq_haseeb — Mon, 22 Sep 2014 06:57:46 GMT

Hi,

Check if this helps

regards

ASHFAQ

Re: Toggle views in a chart

Mon, 22 Sep 2014 06:59:36 GMT

Thanks Amit, this dose the trick. Have fun, Matthias

Re: Toggle views in a chart

amit_saini — Mon, 22 Sep 2014 07:17:01 GMT

Cheers

Thanks,