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

Different expressions for different dimensions in a cyclic drill

Hi,

I have a cyclic drill, which has dimensions D1, D2, D3 and I want to use 3 different expressions for these dimensions. That is, when dimension D1 is selected expression E1 should be active, if D2 then E3 must be active and so on. Is this possible?

1 Solution

Accepted Solutions
Not applicable

if(GetCurrentField(Specialty)='Physician Specialty',1,0)

View solution in original post

7 Replies
Not applicable

GetCurrentField(YourCycle) will return the name of the dimension currently displayed

If used with if() you may change the expression according to your wishes.

Fabrice

Nicole-Smith

Are you using QV11?  You can make the expressions conditional:

Then for expression E1, your conditional statement should look something like:

GetCurrentField([Your Group Name]) = 'D1'

polisetti
Creator II
Creator II
Author

Your cycle means the name of the cyclic drill??

Not applicable

Yes sir

Not applicable

you should try below in your expression in condition

Untitled.png


polisetti
Creator II
Creator II
Author

if(GetCurrentField(Specialty)=Physician Specialty,1,0)

if wrote this expression, where Specialty is my drill group name and physician specialty is my field name contained in the drill.

It is not working, is it wrong?

Not applicable

if(GetCurrentField(Specialty)='Physician Specialty',1,0)