topic Re: STACK chart it is possible to display only positve value ? in QlikView

STACK chart it is possible to display only positve value ?

paulyeo11 — Fri, 12 Jul 2013 12:32:07 GMT

Hi All,

my exp have positive value and negative value.

my stack chart have positive value and negative value , i wish to display the only result value ( see line chart below ), meaning the total amount same as my line chart , but display in stack chart. so i can view the total monthly expense by month using stack chart.

Below is the line chart which display the correct value . i need the line chart total amount , since it is correct , and add stack chart , since able stack chart have positive and negative value/

Both chart are correct , but i wish to make the stack appear in line chart. with out changing the line charge total amount , it is possible ?

Re: STACK chart it is possible to display only positve value ?

swuehl — Fri, 12 Jul 2013 13:35:45 GMT

Looking at your stacked bar chart, the total amount per bar would be negative, correct? So I don't understand the values shown in your line chart.

Besides this, how do you want to show the distibution of positive and negative values in the new chart, resulting in something comparable to the line chart total amount? Could you post a sketch drawing how that should look like?

Re: STACK chart it is possible to display only positve value ?

paulyeo11 — Fri, 12 Jul 2013 23:17:07 GMT

Hi swuehl

i use fabs for line chart. to make it shows +ve.

money(

fabs(

sum({$<year = {$(=max(year))}

,NAME_PNL = {"4 EXP"}

, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}Amount/$(ColumnDim98))/1000

)

, $(vMoneyFormatK_GL))

your second question make realise it is not possible. unless you are magician.

thank.