Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get the click action in Qlikview Cyclic Group

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,

1 Solution

Accepted Solutions
m_woolf
Master II
Master II

If your group is defined similar to the pic below:

GroupDef.png

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))

View solution in original post

2 Replies
m_woolf
Master II
Master II

If your group is defined similar to the pic below:

GroupDef.png

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))

Not applicable
Author

Thank you so much!