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: 
paulyeo11
Master
Master

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

Hi,

maybe like this?

QlikCommunity_Thread_161674_Pic1.JPG

hope this helps

regards

Marco

View solution in original post

3 Replies
paulyeo11
Master
Master
Author

Enclosed my Qv Doc

MarcoWedel

Hi,

maybe like this?

QlikCommunity_Thread_161674_Pic1.JPG

hope this helps

regards

Marco

paulyeo11
Master
Master
Author

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