topic Using the cyclic dimension in an aggr statement (GetCurrentField) in QlikView

Using the cyclic dimension in an aggr statement (GetCurrentField)

Wed, 08 May 2013 12:55:12 GMT

I have a chart that has a cyclic dimension. The measure (Y axis) has an aggrregate statement as follows :

aggr(sum(Data) ,Type, GetCurrentField([FisMo / Qtr]) )

([FisMo / Qtr] this is the cyclic dimension - it selects either fiscal month or fiscal quarter.

When I switch between fiscal month and fiscal quarter on the dimension using the cyce button, I need to change the aggr statement to reflect that. Thus I use "GetCurrentField([FisMo / Qtr])" ( in place of Fiscal Month and Fiscal Qtr.)

Although GetCurrentField([FisMo / Qtr]) works everywhere in Qlikview ( in a text box for example ) to show the current dimension cycle, it will NOT work when placed in the aggr statement. The chart stops calculating as soon as I insert "GetCurrentField([FisMo / Qtr])" in place of the fiscal month or fiscal quarter.

Does anyone have a workaround for this?

Thank,

Jim

Re: Using the cyclic dimension in an aggr statement (GetCurrentField)

Gysbert_Wassenaar — Wed, 08 May 2013 13:01:17 GMT

Try aggr(sum(Data) ,Type, $(=GetCurrentField([FisMo / Qtr])) )

Re: Using the cyclic dimension in an aggr statement (GetCurrentField)

Wed, 08 May 2013 13:07:50 GMT

Gysbert - You are the master - it works - a big thank you.

The folks on this community are great!

My only regret is not asking sooner - I spent over an hour on this last night.

Jim

Re: Using the cyclic dimension in an aggr statement (GetCurrentField)

prodanov — Mon, 07 Apr 2014 18:19:46 GMT

You haven't to use this function. Try only with name of group - aggr(sum(Data) ,Type, [FisMo / Qtr])

Re: Using the cyclic dimension in an aggr statement (GetCurrentField)

raynac — Thu, 04 Apr 2019 14:05:30 GMT

This is so strange...I tried this with a cycle of Year, Month, Day, W/E and DOW...it looked amazing and I had thought it was working but as I cycled through, the first three worked like a charm and the W/E and DOW were blank.