Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
jadams123
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
Vegar
MVP
MVP

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)

View solution in original post

4 Replies
jadams123
Creator
Creator
Author

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. 

Vegar
MVP
MVP

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)
Vegar
MVP
MVP

You might want to adjust the expression to this
Sum([FY budget] * $(=max(BudgetMonth)) / 12)
HirisH_V7
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