Creating scorecard from a flat excel to be automated within a qlikview report. I believe it will contain a lot of calculated conditions within the columns but I do not know the best way/object to display this data.

[#1]

I am looking to create a report that management uses as a scorecard from a flat excel to be automated within a qlikview report. I believe it will contain a lot of calculated conditions within the columns but I do not know the best way/object to display this data.

Some of the information or columns I would use would be like these below. Each of these columns would be calculated conditions I feel, but I do not know the best way to display this data in a qlikview report that would then pull and update from our fields. Any direction or guide to this would be great.

	Annual Baseline (Prior Year)	Forecaste/Goal by Month	Vari from (Actual vs Budgeted)	Current Month	Year-to-Date Actual	% of Annual Forecast	Annual Forecast
Sales
Bookings
Bookings GP%
Sales ($)
GP ($)
GP %