Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

Automate numbering months

Hi:

 

I have a column that has a FY budget of $1MM

If the user selects Jan then $1MM * (1/12),

if the user selects Feb then $1MM * (2/12),

if the user selects March then $1MM * (3/12)

How can I do this?

Thanks, 

J

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

A month field are normally a dual value field, meaning it consist of both a text value (Jan, Feb ... Dec) and a numeric value (1, 2 ... 12). If your BudgetMonth field is a dual then you could use this expression:

Sum([FY budget] * BudgetMonth / 12)
Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

4 Replies
Highlighted
Creator
Creator

Oh by the way I am a front end user. I have no access to loading data. I can only play around with dim and expressions. 

Highlighted
Partner
Partner

A month field are normally a dual value field, meaning it consist of both a text value (Jan, Feb ... Dec) and a numeric value (1, 2 ... 12). If your BudgetMonth field is a dual then you could use this expression:

Sum([FY budget] * BudgetMonth / 12)
Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

Highlighted
Partner
Partner

You might want to adjust the expression to this
Sum([FY budget] * $(=max(BudgetMonth)) / 12)
Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Highlighted
Master
Master

Might use getselectedfield in variable and use it there. So that user selection will effect there. or else max condition will work as default.

HirisH
“Aspire to Inspire before we Expire!”