2 Replies Latest reply: May 16, 2018 10:55 PM by Archana handu RSS

    Filter selection in Qliksense

    Archana handu
      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