Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
d4rlie891
Contributor III
Contributor III

How to create a Line Chart for this subtraction

Hi,

Anyone can help me how to create a line chart for this measure :

sum({$<TAHUN = {"$(=max(TAHUN))"}, YEAR_MONTH_CAL>} COMM_ORIG_AMT_IDR_PLF) 

-

(sum({$<YEAR_MONTH_CAL = {"$(=max(YEAR_MONTH_CAL))"}>} BALANCE_IDR) - sum({<TAHUN={$(=max(TAHUN)-1)},NUM_BULAN_C={12}, YEAR_MONTH_CAL>}BALANCE_IDR))

Thanks

1 Reply
Gysbert_Wassenaar

Add a line chart object to your sheet. Choose a field to use as dimension and add that to the chart. Then add your expression as chart expression. Done.


talk is cheap, supply exceeds demand