Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
It could be done like this:
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.
Sorry I didn't notice ... but yes it is applicable to Qlik Sense as well... I can give you a Sense example instead...
Yes than you, I would appreciate it.
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....