Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
j_schmidt
Contributor

Filter pane | Searching for 'greater than'

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!

1 Solution

Accepted Solutions
vinieme12
Esteemed Contributor II

Re: Filter pane | Searching for 'greater than'

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

8 Replies
j_schmidt
Contributor

Re: Filter pane | Searching for 'greater than'

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.

laddu_927
Valued Contributor

Re: Filter pane | Searching for 'greater than'

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

vinieme12
Esteemed Contributor II

Re: Filter pane | Searching for 'greater than'

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

j_schmidt
Contributor

Re: Filter pane | Searching for 'greater than'

in my case dates are numbers.

vinieme12
Esteemed Contributor II

Re: Filter pane | Searching for 'greater than'

can you post a sample app

j_schmidt
Contributor

Re: Filter pane | Searching for 'greater than'

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
Esteemed Contributor

Re: Filter pane | Searching for 'greater than'

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

See the image below:

Capture.PNG

j_schmidt
Contributor

Re: Filter pane | Searching for 'greater than'

Yes my date was a number.

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

Thanks