topic Detaching the Objects Permanently in QlikView

Detaching the Objects Permanently

Wed, 29 Jun 2011 12:03:02 GMT

Good Evening Everybody,

As I have a qlikview report it contains 2 sheets. Sheet 1 contains the summary of sales per client sheet 2 contains the all values of sales.

My requirement is when I select the customer name in sheet 2 the impact is on sheet one also, but it should not change the value in sheet 1.

I tried detaching the objects but when I close and reopen the qlw file the detachment is gone.

Any suggestions how to detach permanelty from sheet 2.

Thanks in advance.

Joe V

Detaching the Objects Permanently

nagaiank — Wed, 29 Jun 2011 12:30:13 GMT

You can save the selections in a bookmark, save it and clear the selections when you exit the sheet using triggers.

There was an example given in one of the discussion threads in this forum, though I am not able to find it now.

So play with triggers to do this.

Detaching the Objects Permanently

Wed, 29 Jun 2011 12:46:05 GMT

Hello Joe,

I was able to retrace the described behaviour. Feature or Bug ? Anyway, I suggest to try a workaround using SET Analysis within the expression(s) of your chart. Use it similar to this snippet copied from Help:

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.

Regards, Roland