Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Dynamic reference lines Based cyclic group dimension.

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.

1 Solution

Accepted Solutions
pat_agen
Valued Contributor

Dynamic reference lines Based cyclic group dimension.

hi,

try the getcurrentfield() function

getcurrentfield ( GroupName  )

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

Example

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.

4 Replies
pat_agen
Valued Contributor

Dynamic reference lines Based cyclic group dimension.

hi,

try the getcurrentfield() function

getcurrentfield ( GroupName  )

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

Example

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.

Not applicable

Dynamic reference lines Based cyclic group dimension.

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

Thanks,

Byron

Not applicable

Re: Dynamic reference lines Based cyclic group dimension.

Hi,

this is my file,

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

Thanks.

Not applicable

Dynamic reference lines Based cyclic group dimension.

Thanks pat.agen,

It is working fine..

Community Browser