Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
Would you be able to share a sample application where you are trying to get this done?
Hi,
Here attached sample qvw ,where I wanted to show Total Bar as 1st bar then followed by Revenue values descending order.
Something like this? But with Quarters going downwards?
Yes Sunny!!
Hi,
Can you please attach the qvw file whit the changes!!
Here you go
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!!
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
];