How to write this logical expression - Qlik Community

Anonymous · ‎2018-10-08

I have a question when I use this extension

It can set the initial selection just like this, when I set the 'initial selection' as '>201801',it works.

But when I set the 'initial selection' as '>201801 and <201804',it can't work and was shown like this.

I don't know how to deal with it

petter · ‎2018-10-09

It behaves like a search so the right way of doing the selection would be to have this expression:

>201801<201804

Leave out the and since it follows the syntax of a search expression like in a set analysis/expression or in the UI with list box/filter pane searches.

petter · ‎2018-10-09

Anonymous · ‎2018-10-09

Wow! It works. Thanks Petter!

Anonymous · ‎2018-10-09

Hi Petter:

An additional question, I just set a variable called 'YMStart' as '=year(Today())*100+1' and then set the 'initial selection' as '>YMStart', it didn't work. What wrong about this?