Locking chart in a sheet

[nadkalyan]

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

[MayilVahanan · Accepted solution]

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

[#3]

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

[nadkalyan]

Thanks Mayil,

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

Kalyan