Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

arusanah
Contributor

Filter selection in Qliksense

Main Tablevaluetable-1table-2
Date
Date-1intDate1filter tDate2Filter
Date-2inDate-1inDate-6out
Date-3inDate-2inDate-7out
Date-4inDate-3inDate-8out
Date-5inDate-4in
Date-6outDate-5in
Date-7outDate-7out
Date-8outDate-8out
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
1 Solution

Accepted Solutions
vinieme12
Esteemed Contributor II

Re: Filter selection in Qliksense

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

2 Replies
vinieme12
Esteemed Contributor II

Re: Filter selection in Qliksense

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
Contributor

Re: Filter selection in Qliksense

Thank you for your help Vineet!!

Community Browser