topic Re: cyclic dimension in an expression - using GetCurrentField ? in QlikView

cyclic dimension in an expression - using GetCurrentField ?

Thu, 05 Sep 2013 10:58:02 GMT

Hi there,

I have this expression that gives me the share of a given dimension every month :

=Sum(Volume) / Sum(TOTAL<Month> Volume)

Instead of displaying only [Month], I want to display a [Time Period] cyclic group that toggles between [Month] or [Cal. Quarter].

I have written an expression using GetCurrentField that displays the share according to what [time period] you select in the cyclic group, but it does not work :

=Sum(Volume) / Sum (TOTAL<(=GetCurrentField([Time period])> Volume))

Anybody has an idea of what i am doing wrong ?

Thank you,

Julien

Re: cyclic dimension in an expression - using GetCurrentField ?

Gysbert_Wassenaar — Thu, 05 Sep 2013 11:05:13 GMT

Try using a helper variable. See attached qvw

Re: cyclic dimension in an expression - using GetCurrentField ?

stigchel — Thu, 05 Sep 2013 11:59:21 GMT

There is ")" misplaced and you need the "[]" brackets around the field in total for the [Cal. period] field. I tested the following expression in your document and it works:

=Sum(Volume) / Sum (TOTAL <[$(=GetCurrentField([Time period]))]> Volume)

Re: cyclic dimension in an expression - using GetCurrentField ?

Thu, 05 Sep 2013 12:38:25 GMT

Both solutions work actually! Thank you both !

Julien

Re: cyclic dimension in an expression - using GetCurrentField ?

Thu, 05 Sep 2013 12:38:30 GMT

Both solutions work actually! Thank you both !

Julien

Re: cyclic dimension in an expression - using GetCurrentField ?

stigchel — Thu, 05 Sep 2013 12:59:00 GMT

You're welcome, I forgot to mention that the "$" was missing in your expression (dollar sign expansion).

Also could you mark an answer as a correct answer, it marks the question answered and will help others to find answers. Should you not know which one to mark as correct, please mark Gysbert's answer as correct, he was definitely first.

Re: cyclic dimension in an expression - using GetCurrentField ?

cspindley — Tue, 15 Sep 2020 15:09:11 GMT

ty Gysbert, Clive