topic Stacked Chart - Values and Labels in QlikView

Stacked Chart - Values and Labels

Thu, 18 Jun 2015 14:20:09 GMT

Hi,

My query is regarding stacked charts. My requirement is to create a stacked chart where the label is not equal to the value.

Consider an example where there is a stacked chart. X-axis (dimension) is Year (2011, 2012, 2013 and 2013) and Y-axis is the stacked data for total number of flights for various airlines companies (American Airlines, Air Asia, Qataar Airways) i.e gives the count. Now, for Air Asia in particular if the # of flights is 3000 then the label on the bar should read 'Three Thousand'. Is there a way to have the labels distinct from the values in stacked charts?

Thanks in advance!

Re: Stacked Chart - Values and Labels

stigchel — Thu, 18 Jun 2015 14:47:49 GMT

Yes you can use a dual function in the expression, Dual(Text,Value) and check the values on datapoints and maybe the plot values inside segments in the presentation tab.

For example (you may have to change the text representation to your needs)

Dual(Sum(Amount)/pow(10,(len(Sum(Amount))-1))&' '&pick((len(Sum(Amount))-1),'(1)','(10)','thousands')

,Sum(Amount))

Re: Stacked Chart - Values and Labels

Fri, 19 Jun 2015 10:21:35 GMT

Thank you for the response! This solution worked perfectly for me!

Re: Stacked Chart - Values and Labels

happydays1967 — Tue, 17 May 2016 15:00:51 GMT

Thanks! Saved a lot of time. One addition: on the 'Number' tab, set the number representation to 'Expression default' otherwise it will not show the text...