topic Dynamic Calculation based on User Selected Value in QlikView

Dynamic Calculation based on User Selected Value

Tejeswari_123 — Thu, 21 Jul 2022 10:25:25 GMT

Hello Team,

We have one requirement like we have 2 columns year and forecast value. We are trying to present the future forecast value based on the current year selection where forecast value will be sum of all future years based on current Year selection. I am giving condition based on

year>= current selection, but we are not getting Expected values.

Can anyone help me here?

Re: Dynamic Calculation based on User Selected Value

ramasaisaksoft — Thu, 21 Jul 2022 11:06:44 GMT

For this calculation, you need to create a variable

let VlYear=getfieldselections(Year) Ex:- like this getfieldselections(Product)

then in your set analysis need to use that variable in calculation.

FYI...

GetFieldSelections() function

The GetFieldSelections() function returns the values that are selected in a particular field. This function returns a string or text value.

Syntax:

GetFieldSelections(field_name [, value_sep [, max_values [, state_name]]])

Where, field_name is the name of the field from which you wish to get the selected values.

value_sep is the separator used between field values. Such as ‘,’.

max_values sets the maximum number of field values that can be listed individually. The default value is set to 6.

From the state_name parameter, you can mention an alternate state of the visualization, if present.

Re: Dynamic Calculation based on User Selected Value

Tejeswari_123 — Thu, 21 Jul 2022 12:09:05 GMT

Hello Rama,

We have tried with this function but still we are not getting Expected values