topic Re: Locking chart in a sheet in QlikView

Locking chart in a sheet

nadkalyan — Fri, 13 Jul 2012 15:56:09 GMT

Hi ,

I have a Qlikview sheet Dashboard with several sheet objects - List box, straight tables , charts.

In this sheet i would like to lock the chart to a particular view of data, so which means no matter what ever data I select in other listbox or straight table, the chart should not be changed with those selections.

I tried Detach Option on the chart but that doesnot seem to work when i reload the qlikview file.

Any suggestions?

Thanks

Kalyan

Re: Locking chart in a sheet

MayilVahanan — Fri, 13 Jul 2012 16:00:00 GMT

HI,

=Try like this,

Use expression somthing like this..

sum( {1} Sales )

returns total sales within the application, disregarding the selection but not the dimension. If used in a chart with e.g. Products as dimension, each product will get a different value.

sum( {1} Total Sales )
returns total sales within the application, disregarding both selection and dimension. I.e. the same as sum(All Sales).

( or)

If you use qlikview -11 , use alternate state. you can set alternate state in Settings- document properties - general - alternate state.

By using this, no change in chart..

Hope it helps

Re: Locking chart in a sheet

Fri, 13 Jul 2012 16:30:40 GMT

save selection to a bookmark and appla this bookmark onpostreload document trigger..

Re: Locking chart in a sheet

nadkalyan — Fri, 13 Jul 2012 16:55:00 GMT

Thanks Mayil,

That worked like a charm. By the way it qlikview-10 solution.

Kalyan