Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to write this logical expression

I have a question when I use this extension

1.JPG

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

2.JPG

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

3.JPG

4.JPG

I don't know how to deal with it

4 Replies
petter
Partner - Champion III
Partner - Champion III

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
Partner - Champion III
Partner - Champion III

2018-10-09 21_15_57-Qlik Sense Desktop.png

Anonymous
Not applicable
Author

Wow! It works. Thanks Petter!

Anonymous
Not applicable
Author

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?