Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Toggle views in a chart


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

waterfall_abs.png

waterfall_proc.png

1 Solution

Accepted Solutions
amit_saini
Master III
Master III

8 Replies
sujeetsingh
Master III
Master III

You can use bar offset

amit_saini
Master III
Master III

sushil353
Master II
Master II

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

ashfaq_haseeb
Champion III
Champion III

Like this

Regards

ASHFAQ

jagan
Partner
Partner

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.

ashfaq_haseeb
Champion III
Champion III

Hi,

Check if this helps

regards

ASHFAQ

Not applicable
Author

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

amit_saini
Master III
Master III

Cheers

Thanks,

AS