topic Re: How to create variance from 2 month total customers? in QlikView

How to create variance from 2 month total customers?

Thu, 19 Jul 2012 01:45:04 GMT

I have 3 fields -

1) type of account A,B,C

2) total customers

3) month id - 201206 and 201112

I would like to create variance by total customers by type of account for the 2 month id.

I am using create expression to create

1) Current month total customers -

sum

({date={'2012-06'},[Mth Id]}[total Cust])

2) previous month total customers

sum({<date={"$(=Date(AddMonths(date,-6),'YYYY-MM'))"},[Mth_Id]=>}[Total Cust])

3) variance

[current month total customers] - [previous month total customers]

But the above does not work. Anyone can help?

Thu, 19 Jul 2012 07:38:12 GMT

Hi,

What is the logic to select the two months? I mean would you always need Variance between those two months?

Regards

Thu, 19 Jul 2012 09:07:52 GMT

check your syntax, it should be:

1) Current month total customers

sum({$<date={'2012-06'},[Mth Id]=>}[total Cust])

2) previous month total customers

sum({$<date={"$(=Date(AddMonths(date,-6),'YYYY-MM'))"},[Mth_Id]=>}[Total Cust])

3) variance

[current month total customers] - [previous month total customers]