Filter selection in Qliksense

arusanah — Wed, 16 May 2018 03:38:01 GMT

Main Table	value	table-1		table-2
Date
Date-1	in	tDate1	filter	tDate2	Filter
Date-2	in	Date-1	in	Date-6	out
Date-3	in	Date-2	in	Date-7	out
Date-4	in	Date-3	in	Date-8	out
Date-5	in	Date-4	in
Date-6	out	Date-5	in
Date-7	out	Date-7	out
Date-8	out	Date-8	out
I am having 3 table . one-Main Table, and two derived tables . I am using Date field from table1 in first sheet and Date field from table -2 on second sheet. I am using below expression to sum(value). My requirement is to sum for only tdate1 on sheet 1. and it souldn be affected by any selection on tDate2. so i created following set analysis Sum({<tDate1=p[Date], tDate2=>} Value) & vice versa. but what happens when i make selection of sheet one on tDate1 filter and go to page 2 and try to make selections on sheet 2. it overrides selection on sheet 1 . my requirement is " it should hold both the selections

Re: Filter selection in Qliksense

vinieme12 — Wed, 16 May 2018 03:59:46 GMT

your set analysis should be the other way round

Sum({<Date=p[tDate1]>} Value)

table1 and table2 should be disconnected island tables, you should not need to specify ,tDate2= here

arusanah — Thu, 17 May 2018 02:55:23 GMT

Thank you for your help Vineet!!