topic Re: Using Cyclic Dimension in chart expression in QlikView

Using Cyclic Dimension in chart expression

prees959 — Sun, 24 Sep 2017 14:36:03 GMT

Hi,

I currently have this expression in a 100% stacked bar chart :

=sum([Count])/sum(TOTAL <Date> [Total ])

I would like to have a Cyclic Date group as a dimension. is it possible to use a cyclic group in the expression in place of the Date dimension??

Many thanks.

Phil

Re: Using Cyclic Dimension in chart expression

swuehl — Sun, 24 Sep 2017 14:39:30 GMT

You can either use a dollar sign expansion with GetCurrentField() to get the active field of your dimension group, or just use all fields of the group in the TOTAL field list, like

=sum([Count])/sum(TOTAL <Date, Month, Year> [Total ])

or something like

=sum([Count])/sum(TOTAL <[$(=GetCurrentField(DateGroup))]> [Total ])