How to get the click action in Qlikview Cyclic Group

[#1]

Hi all,

I meet a question when I use Cyclic group:

I am calculating the annual rate of something. I built a group (Year-Quarter-Month). Now what I need to do is once I expand the group from year to quart, the rate need to be multiplied 4 so that it can be an annual rate. I am wondering whether qlikview can build this function under the expression block.

Thank you and Best regards,

[m_woolf · Accepted solution]

If your group is defined similar to the pic below:

You can use : =SubField(GetCurrentField(TimeGroup),'//', 2)  to determine which item is currently selected.

So your expression could be something like:

=if(SubField(GetCurrentField(TimeGroup),'//', 2),Rate*2,

     if(SubField(GetCurrentField(TimeGroup),'//', 2),Rate*4,Rate*8))

[#3]

Thank you so much!