topic Re: Looping for Offset in QlikView

Looping for Offset

Tue, 07 Jan 2014 10:22:59 GMT

Hi All,

I know how to do offset for a bar graph.

But i have to do manually for each Expression and offset for it.

Attached is the QVW. Please check it.

Is there any other way to do this.

Can we loop it ???

Thanks & Regards,

Keerthi

Re: Looping for Offset

Wed, 08 Jan 2014 11:03:20 GMT

Hi all,

Is there any other way to this ??

Regards,

Keerthi

Re: Looping for Offset

Wed, 08 Jan 2014 11:09:47 GMT

Hi Keerthi,

For the offset you can't not loop it. But if you are using the same expression for all bar offsets then declare a variable and call that variable in Bar offset, instead of copy pasting big expression you can call that variable.

Re: Looping for Offset

bbi_mba_76 — Wed, 08 Jan 2014 12:15:11 GMT

Hi,

you could use the expression name or che column() function:

ie you could set as offset

=Withdrawn+Paid

=column(1)+column(2)

and so on

Re: Looping for Offset

Fri, 10 Jan 2014 06:41:02 GMT

I will try this.

Re: Looping for Offset

Fri, 10 Jan 2014 06:41:23 GMT

Santhosh i am using different expressions