Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello developers,
In QlikSense, I know I can do this filter so it gets me x amount of dates:
The thing is, I save it in a Bookmark and the function it returns me is this one:
I'm trying to replicate this filter formula for my NPrinting filters, but it´s not working, I think I have to put it in advanced search and tried, but wasn´t succesfull.
What am I doing wrong?
Thanks!
Also - here is a sample of article with syntax for advanced search
https://community.qlik.com/t5/Member-Articles/Examples-of-Advanced-Search-Filters/ta-p/1594779
@DiegoF what version is your NPrinting and QlikSense on?
Can you share a screenshot from NPrinting as well?
And QlikSense (August 2022)
I did tried a couple of times with some filter in the report but the error is just that is False, the condition I guess it´s just wrong
Hi @DiegoF
It can be done but....
Filters can be challenging if you dont understand what data type they are. Please read through the below links (make sure you follow links which are embedded as well as they describe more details on why/ how/ etc).
Now - for your solution in theory you could use "Advanced Search" filter, but its use may be questionable if you have other filters which cause selection state to change.
Best practice in your case would be to have field loaded in your load script like:
Cheers
Also - here is a sample of article with syntax for advanced search
https://community.qlik.com/t5/Member-Articles/Examples-of-Advanced-Search-Filters/ta-p/1594779
Thanks! The first link solved it for me, I didn´t knew you could use like in advanced search, so my dynamic filter is this one:
=FECHA like '*6/2023*
I´m guessin that all the other wildcards will work with like aswell, I love to learn that things I know can be applied somehow in qliksense.
Thank you!
Yes - that can work, just remember that advanced search will only filter values within current selection if other filters are applied.