topic Re: Different expressions for different dimensions in a cyclic drill in QlikView

Different expressions for different dimensions in a cyclic drill

polisetti — Mon, 24 Feb 2014 16:25:21 GMT

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?

Re: Different expressions for different dimensions in a cyclic drill

Mon, 24 Feb 2014 16:27:54 GMT

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

Re: Different expressions for different dimensions in a cyclic drill

Nicole-Smith — Mon, 24 Feb 2014 16:28:15 GMT

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'

Re: Different expressions for different dimensions in a cyclic drill

polisetti — Mon, 24 Feb 2014 16:42:20 GMT

Your cycle means the name of the cyclic drill??

Re: Different expressions for different dimensions in a cyclic drill

Mon, 24 Feb 2014 16:49:13 GMT

Yes sir

Re: Different expressions for different dimensions in a cyclic drill

Mon, 24 Feb 2014 16:54:35 GMT

you should try below in your expression in condition

Re: Different expressions for different dimensions in a cyclic drill

polisetti — Mon, 24 Feb 2014 16:55:32 GMT

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?

Re: Different expressions for different dimensions in a cyclic drill

Mon, 24 Feb 2014 17:13:16 GMT

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