topic Re: Variable Field Names in QlikView

Variable Field Names

stuartbeet — Thu, 02 Feb 2012 11:33:50 GMT

Hi,

I need to store annual budget values against a customer. I'm looking at creating:

Cus_Budget_2010

Cus_Budget_2011

Cus_Budget_2012 .... etc

I have a calendar file which dictates the selected date or month or year etc from the sales date. When the user selects Year I need to select the appropriate Cus_Budget_Year value.

Question: Is there a way to write an expression which matches the selected year to the cus_budget_year OR is there a better way to structure this?

Any help would be appreciated!!

Many thanks

Variable Field Names

gussfish — Fri, 03 Feb 2012 03:01:44 GMT

Just add another field called 'Year', to contain 2010 or 2011 etc, so that you have a record per year.

Re: Variable Field Names

Miguel_Angel_Baeyens — Fri, 03 Feb 2012 04:26:04 GMT

Hi,

It is indeed possible, as in the attached file. But I'm not sure how it will perform with thousands of records, and I agree with Angus that the best way of doing that is creating a date field for each record that links to the master calendar, and then, using set analysis as in this application, the charts will display values from one year or another depending on the selections the user does.

Hope that helps.

Miguel

Variable Field Names

stuartbeet — Sun, 05 Feb 2012 17:16:24 GMT

Thanks Angus, sorted!