Current month Plus previous half year

Ask a Question

Hi Qlik Community Members,

My Business is looking for a line chart

Say for Current Year 2018 budget they are looking for whole year (Jan to DEC )and second half year budget of 2017(Jul-DEC).

Second line for Actuals for 2018 ( YTD) and previous half year of 2017 (Jul-DEC) .

Third line just second half year of prior year 2016(JUl -DEC).

FORMAT they are looking for below image (X axis with Month for 18 months of budget., Actuals, Prior year Actuals)

What I was able to accomplish

My Question is how do I accomplish as in first picture. Is this possible in qlik ?

0 Replies