1 Reply Latest reply: Oct 29, 2015 11:22 PM by Settu Periyasasamy RSS

    qlikview table filter forcing wrong filter

      Using qlikview 8 personnel edition.

      On my main tab i have a chart table that concats year and period (year and month) from this I use it as a filter to select periods, this works fine except when trying to select multiple years and periods, it allows selection but say:

      Select all from year 2013, and up to year 2014 month 09. It actually selects all from 2013 and 2014.

      why would it be doing this?

      Some details:

      =Num#(If(Len(Year & Period)=5,Year & '0' & Period, Year & Period))

      outputs "201301" etc

      Like I said i can select whatever month up to a month i want within a year. However doing the same over multiple years forces it to select all months.