topic Re: Add field from cyclic group in TOTAL expression in QlikView

Add field from cyclic group in TOTAL expression

kolov007 — Wed, 07 Jun 2017 11:00:37 GMT

I have a problem.

I need to add a current field from cyclic group in Total expression, but my expression doesn't work with function:

Please, help me to solve this task.

Re: Add field from cyclic group in TOTAL expression

MK_QSL — Wed, 07 Jun 2017 11:05:42 GMT

May be use

$(=GetCurrentField(Stat_gr_expr))

Re: Add field from cyclic group in TOTAL expression

Anil_Babu_Samineni — Wed, 07 Jun 2017 11:07:49 GMT

Just add $() for your Current field and let me know

Re: Add field from cyclic group in TOTAL expression

sunny_talwar — Wed, 07 Jun 2017 11:08:39 GMT

For spaces in field... you can further add this

$(='[' & GetCurrentField(Stat_gr_expr) & ']')

Re: Add field from cyclic group in TOTAL expression

swuehl — Wed, 07 Jun 2017 11:19:30 GMT

You can either use a dollar sign expansion using GetCurrentField() ...

... or just add all fields from the cyclic group to the TOTAL qualifier field list.

From the HELP:

TOTAL qualifier

Using the total qualifier inside your aggregation function disregards the dimensional value.

The aggregation will be performed on all possible field values.

The TOTAL qualifier may be followed by a list of one or more field names within angle brackets. These field names should be a subset of the chart dimension variables. In this case, the calculation is made disregarding all chart dimension variables except those listed, that is, one value is returned for each combination of field values in the listed dimension fields. Also, fields that are not currently a dimension in a chart may be included in the list. This may be useful in the case of group dimensions, where the dimension fields are not fixed. Listing all of the variables in the group causes the function to work when the drill-down level changes.

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/ChartFunctions/define-aggregation-scope.htm

Re: Add field from cyclic group in TOTAL expression

sunny_talwar — Wed, 07 Jun 2017 11:23:21 GMT

That's a great idea, but the list of dimensions within the cycle group might be huge and might make it difficult to manage. Good option for Qlik Sense where GetCurrentField is not an option