topic Re: Automate numbering months in QlikView

Automate numbering months

jadams123 — Wed, 25 Nov 2020 16:16:04 GMT

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,

Re: Automate numbering months

jadams123 — Thu, 21 Mar 2019 18:28:18 GMT

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.

Re: Automate numbering months

Vegar — Thu, 21 Mar 2019 18:48:31 GMT

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)

Re: Automate numbering months

Vegar — Thu, 21 Mar 2019 18:50:45 GMT

You might want to adjust the expression to this
Sum([FY budget] * $(=max(BudgetMonth)) / 12)

Re: Automate numbering months

HirisH_V7 — Thu, 21 Mar 2019 20:53:50 GMT

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