Narrower selection of data

[Anonymous]

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

[petter]

It could be done like this:

[Anonymous]

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]

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

[Anonymous]

Yes than you, I would appreciate it.

[petter]

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.

The script looks like this:

And I have attached the example application....