topic Re: how do on a graph that has a dimension cyclic group containing year and two months to make different calculations. in QlikView

how do on a graph that has a dimension cyclic group containing year and two months to make different calculations.

Mon, 07 Oct 2013 17:12:32 GMT

Good Afternoon,

as I do on a graph that has a dimension cyclic group containing year and two months to make different calculations.

example:

How could I do to select year when he makes a speech and when selected another month's calculation.

Att,

Gysbert_Wassenaar — Mon, 07 Oct 2013 18:41:51 GMT

You can use the getcurrentfield function to retrieve the currently active field in the cyclic group. Something like this:

if(getcurrentfield(MyGroupNameHere)='Year', ...year_expression..., ...month_expression...)

See attached example.

Tue, 08 Oct 2013 16:51:32 GMT

Thank you,