Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
madeleine_josef
Creator
Creator

Narrower selection of data

Hello,

I have an issue with a dataset where I want to make the selection  narrower.

I would like it to give me data where there is a value in my field [ApprovmentSent] but no value in the other field  [ApprovmentDone].

Both of these fields are date fields (YYYY-MM-DD)

Thanks!

/ Madeleine

5 Replies
petter
Partner - Champion III
Partner - Champion III

It could be done like this:

2016-02-26 Narrower selection of data #1.png

madeleine_josef
Creator
Creator
Author

Thank you, I didn't get it to work.

Is applicable in QlikSense aswell? It looks like the code you sent is taken from QlikView.

petter
Partner - Champion III
Partner - Champion III

Sorry I didn't notice ... but yes it is applicable to Qlik Sense as well... I can give you a Sense example instead...

madeleine_josef
Creator
Creator
Author

Yes than you, I would appreciate it.

petter
Partner - Champion III
Partner - Champion III

Here is a Qlik Sense example, but remember to turn of "Show Zeros Values" for the table in "Add On" section of the table settings.

2016-02-26 #3.PNG

The script looks like this:

2016-02-26 #4.PNG

And I have attached the example application....