topic Re: Total Bar in QlikView Dynamic WaterFall Chart in QlikView

Total Bar in QlikView Dynamic WaterFall Chart

Wed, 10 Feb 2016 18:52:59 GMT

Hi ,

I wanted to Show Total Value bar as a 1st bar in QlikView Dynamic Water Fall chart.

I tried sort by expression and Sate Ascending/Descending order, But list of values corresponding bars are getting changing the positions,but Total Bar position is not getting change. It's always displaying at last position.

Any work around to display Total Bar as first bar in dynamic water fall chart.

Appreciate your help!!

Thanks,

Shekar!!

Re: Total Bar in QlikView Dynamic WaterFall Chart

sunny_talwar — Wed, 10 Feb 2016 19:21:51 GMT

Would you be able to share a sample application where you are trying to get this done?

Re: Total Bar in QlikView Dynamic WaterFall Chart

Wed, 10 Feb 2016 19:38:23 GMT

Hi,

Here attached sample qvw ,where I wanted to show Total Bar as 1st bar then followed by Revenue values descending order.

Re: Total Bar in QlikView Dynamic WaterFall Chart

sunny_talwar — Wed, 10 Feb 2016 19:47:54 GMT

Something like this? But with Quarters going downwards?

Re: Total Bar in QlikView Dynamic WaterFall Chart

Wed, 10 Feb 2016 19:49:39 GMT

Yes Sunny!!

Re: Total Bar in QlikView Dynamic WaterFall Chart

Wed, 10 Feb 2016 19:57:32 GMT

Hi,

Can you please attach the qvw file whit the changes!!

Re: Total Bar in QlikView Dynamic WaterFall Chart

sunny_talwar — Wed, 10 Feb 2016 19:58:31 GMT

Here you go

Re: Total Bar in QlikView Dynamic WaterFall Chart

Wed, 10 Feb 2016 20:10:21 GMT

Hi Sunny,

Thanks for your response. But I have one question, in your app sort order expression, you are hardcoding the values like(Q1,Q2,Q3 ),But in my real app sort needs to be apply dynamically?not allowed to hard code the values.

Any work around for the same!!

Re: Total Bar in QlikView Dynamic WaterFall Chart

sunny_talwar — Wed, 10 Feb 2016 20:16:59 GMT

Check out the revised version -> Changes in the script

Test:

LOAD YEAR,

Dual(Quarter, PurgeChar(Quarter, 'Q')) as Quarter,

Revenue

INLINE

[YEAR, Quarter,Revenue

2015, Q1, 20

2015, Q2, 30

2015, Q3, 10

2015, Q4, 40

];

Table:

LOAD * Inline [

Type

];