Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

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.

1 Reply

Re: qlikview table filter forcing wrong filter

Hi,

Try this..

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

Community Browser