Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

stuartbeet
New Contributor II

Variable Field Names

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

3 Replies
gussfish
Contributor II

Variable Field Names

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

Re: Variable Field Names

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

stuartbeet
New Contributor II

Variable Field Names

Thanks Angus, sorted!