Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Stack graph with bigger value at bottom

Hi,

I have following table and graph...now the manager wants the graph to be changed...currently the graph is showing all NA value in bottom of the stack  and SA values at the top of the stack. The manager now wants the highest value to be at the bottom of the stock. So for year 2011 value 180 of SA should be displayed at bottom...and for year 2012 value 200 of NA should be shown at bottom. Any guidance?

20112012
na120200
sa180150

Graph TO BE DELETED.jpg

1 Solution

Accepted Solutions
sudeepkm
Specialist III
Specialist III

Ok I've a workaround to achieve this but needs little more work to align the location (sa and na) in the chart legend.

Or you can simply hide the legends for calc dimension and can use a dynamic text as legend.

Please take a look at the example attached.

chartdimension.png

View solution in original post

5 Replies
sudeepkm
Specialist III
Specialist III

That would change the order of the expression and maybe end user gets confused as the legends order will change. I'm not still sure if that is doable. You can sort based on Y value Asc or Dsc for each year.

Not applicable
Author

Thanks Sudeep for quick response.

I agree that the user is likely to get confused, but that's a user request

Sorting Y axis isn't possible with given data as it has 2 rows/columns that needs to be sorted. Both of them cannot be sorted simultaniously.

sudeepkm
Specialist III
Specialist III

Ok I've a workaround to achieve this but needs little more work to align the location (sa and na) in the chart legend.

Or you can simply hide the legends for calc dimension and can use a dynamic text as legend.

Please take a look at the example attached.

chartdimension.png

Not applicable
Author

Thanksa Sudeep, your answer provides the solution to a large extend.

By any chance did you get chance to check legend issue? For now work around I am following is to have manually added legends.

sunilkumarqv
Specialist II
Specialist II

Hi Pravin,


Change the expressions  using promte and denote on chart properties , I guess it works and need to change littel bit expression as well.

Regards

Sunil