Filter selection in Qliksense

[arusanah]

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

[vinieme12 · Accepted solution]

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]

Thank you for your help Vineet!!