topic Re: Dynamic reference lines Based cyclic group dimension. in QlikView

Dynamic reference lines Based cyclic group dimension.

Mon, 06 Jun 2011 06:21:01 GMT

Hi,

I need to show standared deviation in chart .For that iam caluculating an expression in reference lines option and showing.

for singel dimesion it is working fine.

but my requirement is cyclic dimession for this chart.

based on selected filed that expression has to caluculate...

any help.....

Thanks.

pat_agen — Mon, 06 Jun 2011 07:25:21 GMT

hi,

try the getcurrentfield() function

Returns the name of the currently active field in a group.

getcurrentfield( myGroup )

you can then write an if clause and change your expression depending on the field

=if(getcurrentfield(CyclicGroup)='xyz',sum(abc),

avg(efg))

hope this helps.

Mon, 06 Jun 2011 07:33:55 GMT

Can you upload a test document so that we could see what you are trying to achieve.

Thanks,

Byron

Mon, 06 Jun 2011 08:28:36 GMT

Hi,

this is my file,

if i select Cyclic dimession Service it si working fine but nor OR...

Thanks.

Mon, 06 Jun 2011 08:45:19 GMT

It is working fine..