topic Re: Expression for Calculated Dim!!! in QlikView

Expression for Calculated Dim!!!

buzzy996 — Fri, 03 Aug 2012 07:37:04 GMT

hi,

i have 4 level4 in Selections(Level1,Level2,Level3,Level4)

i need like this--->if i selected Level1 from Selections need to display Level2 objects as X-Axis else

Level2 from Selections need to display Level3 objects as X-Axis else

Level3 from Selections need to display Level4 objects as X-Axis. else Level1.

Could you pls let meknow any one,how to write Expression for Calculated Dim?

thx

Re: Expression for Calculated Dim!!!

Anonymous — Fri, 03 Aug 2012 09:02:03 GMT

Hi,

Please provide some sample data of your model and description of it.

Re: Expression for Calculated Dim!!!

buzzy996 — Fri, 03 Aug 2012 09:18:48 GMT

PFA,

Thanking you for ur quick reply .

Re: Expression for Calculated Dim!!!

Fri, 03 Aug 2012 10:56:03 GMT

Hi,

U can use the drill down using the all Levels.

Is it resolve ur issue?

Regards

Manesh.

Re: Expression for Calculated Dim!!!

buzzy996 — Fri, 03 Aug 2012 11:27:00 GMT

not yet,by drill down all levels can not possible to chnage x-axis!

any help?

Re: Expression for Calculated Dim!!!

Fri, 03 Aug 2012 11:38:28 GMT

try to use

=If(GetSelectedCount(Level4),Level1,If(GetSelectedCount(Level3),Level4,If(GetSelectedCount(Level2),Level3,If(GetSelectedCount(Level1),Level2,Level1))))

as a dimension

Re: Expression for Calculated Dim!!!

ericcosmai — Fri, 03 Aug 2012 11:45:02 GMT

Hi.

Follow what I got and the attached app...

If(GetSelectedCount(Level1)=0,
    if(GetSelectedCount(Level2)=0,
        if(GetSelectedCount(Level3)=0,
            Level1
        ,
            Level4
        )
    ,
        Level3
    )
,
    Level2
)

I hope it helps.

Regards.