Filter pane | Searching for 'greater than'

[schmidtj]

Hi,

i like the simplicity of the Qlik Sense filters but it gives me some headaches, too.

I have a visualisation where i have a filter with date-items in the format DD.MM.YYYY.

However the user needs to set a 'greater than' filter, for example all dates greater then 14.02.2016.

Right now i would have to select all the single days within the option liste of the filter pane.

Anybody has some advice for me?

Thanks a lot!

[schmidtj]

I saw that when i format the date like YYYYMMDD i can then use >, < >=, <= to do a range.

However i would like to stick to the original date format.

[Anonymous]

We can achieve that using conditions involving set analysis. Will you be able to share a sample .qvf??

[vinieme12 · Accepted solution]

dates are also numbers, so are your dates actually dates? or are they text?

[schmidtj]

in my case dates are numbers.

[vinieme12]

can you post a sample app

[schmidtj]

ok you pointed me to the solution already.

my date was a pure number so now i transformed it into:

date(date#([MY_DATE_NUMBER],'YYYYMMDD'), 'DD.MM.YYYY').

Now i can do the range notation with my format DD.MM.YYYY.

Tanks

[OmarBenSalem]

I'm using the format DD/MM/YYYY in my date and can use the >= to filter date !

See the image below:

[schmidtj]

Yes my date was a number.

No it is a Qlik date format and it works fine.

Thanks