topic Actual Column / Budget Column / Variance Column in QlikView

Actual Column / Budget Column / Variance Column

Wed, 29 Jun 2011 21:50:15 GMT

In the attached example I have a column "Expense Type" which has actual and budget. I am trying to have a column with the actual expenses, then a column with budget expenses and a final variance column. Any suggestions?

Re: Actual Column / Budget Column / Variance Column

johnw — Wed, 29 Jun 2011 22:12:07 GMT

Perhaps this:

Actual = sum({<"Expenses Type"={'Actual'}>} "Expenses Amount")
Budget = sum({<"Expenses Type"={'Budget'}>} "Expenses Amount")
Variance = Actual - Budget

Actual Column / Budget Column / Variance Column

Wed, 29 Jun 2011 23:32:16 GMT

Thank you very much!