Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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
Partner - Champion III
Partner - Champion III

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