topic Re: Sheet problems in QlikView

Sheet problems

Wed, 25 Feb 2015 09:23:36 GMT

Hello to everyone.

I have a problem with sheets and charts. When I import .xlsx file, add sheets with charts (have to detach on each sheet charts), save, close and reopen .qvw every chart is on it's default values and I have to do it again. I'v tried to go to properties of chart, taba Expresssions and in Definition type detach, but then I just get chart with default values.

Does anyone know how can I save my charts in sheets without changing to default (I'v tried with bookmarks)?

Re: Sheet problems

MK_QSL — Wed, 25 Feb 2015 10:05:24 GMT

If you detach and chart/graph and reload the apps, the detach will get disabled and attach will by default enabled...

Re: Sheet problems

Wed, 25 Feb 2015 10:08:53 GMT

Ok. But I want to know how can I save my charts (selected values) on different sheets and send to someone (for example) and when that someone open to see my "presentation"

Re: Sheet problems

MK_QSL — Wed, 25 Feb 2015 10:16:00 GMT

Create Bookmarks !

Re: Sheet problems

Wed, 25 Feb 2015 10:23:16 GMT

Is there any other way without bookmarks?

Re: Sheet problems

MK_QSL — Wed, 25 Feb 2015 10:26:32 GMT

May be create bookmark and apply document trigger on post reload...Or wait for some other to come back with a better reply...

Re: Sheet problems

Wed, 25 Feb 2015 11:02:00 GMT

Thank you for reply

Re: Sheet problems

Wed, 25 Feb 2015 12:30:52 GMT

Hi Milos,

All the values resulted in the charts are after some selections in the dimensions right?

Create sheet level triggers to select all such dimensions which result the same values whenever you open the sheet.

i think this would help.

Regards,

Shiva

Re: Sheet problems

awhitfield — Wed, 25 Feb 2015 13:34:15 GMT

When you make selections and then 'save' a qvw, your selections should remain when it's reopened again, that's default behaviour. You should check that there are no Document Triggers that clear selection, either on opening the document OR sheet selection.

Andy