Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Change of expressions.

Hello,

I want to do a thing:

Using a cyclic group, at each change of dimensions also change the expressions.

Does anybody knows if it is possible?

Sincerely, Luiz Bisco

1 Solution

Accepted Solutions
sunny_talwar

You can use a if statement or Pick(Match()) to do that.

Pick(Match(GetCurrentField("YourCycleGroup"), Dimension1, Dimension2, Dimension3), Expression1, Expression2, Expression3)

View solution in original post

3 Replies
sunny_talwar

You can use a if statement or Pick(Match()) to do that.

Pick(Match(GetCurrentField("YourCycleGroup"), Dimension1, Dimension2, Dimension3), Expression1, Expression2, Expression3)

amayuresh
Creator III
Creator III

This is working fine

Cheers,

Mayuresh

jagan
Luminary Alumni
Luminary Alumni

HI,

Try like this

If(GetCurrentField('GroupName') = 'Field1', Expression1,

If(GetCurrentField('GroupName') = 'Field2', Expression2,

'

'

'

')


or You can try Pick() & Match() as Sunny suggested if you have more dimensions in the group.


Regards,

jagan.