topic Re: selection conflict. in QlikView

selection conflict.

arusanah — Thu, 23 Apr 2015 22:54:58 GMT

I Have two reports in same document.

i standard pivot table and other is dynamic report .

for dynamic report i created two calander objects ( fromDate & toDate) . what is happening now is my calendar object overrides my selections for standard report which are based on Year & month dimension.

how can i resolve it ?

Re: selection conflict.

maxgro — Thu, 23 Apr 2015 23:02:51 GMT

I think you have to disregard the selection on the field used in calendar, a date?

if the field is date, try to add a date=

sum( {$<date = >} Sales )

returns the sales for the current selection, but with the selection in “date” removed.

Re: selection conflict.

Anonymous — Fri, 24 Apr 2015 05:35:45 GMT

Hi,

Its a common problem, Actually you need to load stand alone columns (tables) for calender objects that means these tables should not join with any other tables.

Just do a resident load for date column which you want to use inin calendar object and give them different column name.

Thanks

BKC