Total Bar in QlikView Dynamic WaterFall Chart

[#1]

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!!

[sunny_talwar]

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

[#3]

Hi,

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

[sunny_talwar]

Something like this? But with Quarters going downwards?

[#5]

Yes Sunny!!

[#6]

Hi,

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

[sunny_talwar]

Here you go

[#8]

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!!

[sunny_talwar]

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

1

2

];