Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Expression - comparing totals cost between 2 date ranges & calculating difference percentage

Hi

I am looking to produce a straight table which shows by department a comparison between the total costs arising last month (-1) against the total cost arising  for the month  before (-2) and then show the difference percentage between the 2 months

I have the data set - 'costs' and 'creation date', 'creation month' and 'department' (see excel).  I would like to build an expression which totals all the costs with a creation date last month and compare this with the total cost with a creation date that falls in the prior month (-2)

How would I develop such an expression? and how do I ensure this continues to roll on as we progress though the year

Thanks

Rohan

1 Reply

Re: Expression - comparing totals cost between 2 date ranges & calculating difference percentage

See attached example. If you simply add data for new months the expression will automatically show the last two months. If you select a month then it will show that month and the previous month.


talk is cheap, supply exceeds demand
Community Browser