Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
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
Partner - Champion III
Partner - Champion III

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.