qlikview table filter forcing wrong filter

Wed, 28 Oct 2015 09:54:08 GMT

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.

Re: qlikview table filter forcing wrong filter

settu_periasamy — Fri, 30 Oct 2015 03:22:29 GMT

Hi,

Try this..

=Concat(Year&num(Period,00),'|')

topic Re: qlikview table filter forcing wrong filter in QlikView

qlikview table filter forcing wrong filter

Re: qlikview table filter forcing wrong filter