Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

paulyeo11
Not applicable

Existing multiple line chart how to make it stack chart , so i can see the overall total amount by year trend ?

Hi All

How to i hv below working expression , which is working fine :-

money(

sum({$<           year=,          month=,           MonthSeqNum = {"$(= '>=' & only(MonthSeqNum-12) & '<=' & only(MonthSeqNum))"} >}  Amount*-1/$(ColumnDim98)/1000)

, $(vMoneyFormatK_GL))

How it display line chart of individual expense items.

Hope some one can help me make the chart1 to display overall total expense , by change the multiple line chart1 to single line chart or stack line chart. ( same as Table 1 total row amount , display at chart 1.

Paul

1 Solution

Accepted Solutions
MarcoWedel
Not applicable

Re: Existing multiple line chart how to make it stack chart , so i can see the overall total amount by year trend ?

Hi,

maybe like this?

QlikCommunity_Thread_161674_Pic1.JPG

hope this helps

regards

Marco

3 Replies
paulyeo11
Not applicable

Re: Existing multiple line chart how to make it stack chart , so i can see the overall total amount by year trend ?

Enclosed my Qv Doc

MarcoWedel
Not applicable

Re: Existing multiple line chart how to make it stack chart , so i can see the overall total amount by year trend ?

Hi,

maybe like this?

QlikCommunity_Thread_161674_Pic1.JPG

hope this helps

regards

Marco

paulyeo11
Not applicable

Re: Existing multiple line chart how to make it stack chart , so i can see the overall total amount by year trend ?

Thank you very much it work fine now. i need to select the stack bar on the left.