Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

Anonymous
Not applicable
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...

Anonymous
Not applicable
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....