0 Replies Latest reply: Nov 29, 2013 5:32 AM by gufran usmsn RSS

    Simple expression conversion required.

      BranchOpeningDateClosing Date
      A15-10-12 00:00:00NULL
      B01-01-08 00:00:0004:03:11 00:00:00

       

      I have above criteria in database, with Branch A as open still, and Branch B closed.

      In the Qlikview, user can select Year and Month from listbox. He can choose multiple Years or Months from listbox.

       

      I am showing data in Pivot table, like below:qkview.png

      Now here, I want to show only those Branch(s) for which below criteria satisfies:

       

      if (OpeningDate is less than Year and Month) and (ClosingDate is greater than (Year and Month or NULL))
      then

          it should show me Branch

      else

         it should not show

       

      Can anyone translate it to expressions? Thanks in advance.