Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
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)

View solution in original post

amayuresh
Creator III
Creator III

This is working fine

Cheers,

Mayuresh

jagan
MVP
MVP

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.