Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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