Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
dates are also numbers, so are your dates actually dates? or are they text?
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.
We can achieve that using conditions involving set analysis. Will you be able to share a sample .qvf??
dates are also numbers, so are your dates actually dates? or are they text?
in my case dates are numbers.
can you post a sample app
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
I'm using the format DD/MM/YYYY in my date and can use the >= to filter date !
See the image below:
Yes my date was a number.
No it is a Qlik date format and it works fine.
Thanks