Use * in filters, is it possible?

[DiegoF]

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!

[David_Friend]

@DiegoF what version is your NPrinting and QlikSense on?

Can you share a screenshot from NPrinting as well?

[DiegoF]

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

[Lech_Miszkiewicz]

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).

• https://nprintingadventures.com/2022/03/19/filters-in-nprinting-how-hard-can-it-be-part-3-evaluate-v...
• https://nprintingadventures.com/2019/06/26/nprinting-filters-part-3-advanced-search/
• https://nprintingadventures.com/2019/02/15/the-pitfalls-of-nprinting-filters-part-1-dates-and-duals/
• https://nprintingadventures.com/2019/02/25/the-pitfalls-of-nprinting-filters-part-2-search-string-fi...

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:

• Date(Floor(MonthStart(Fecha)),'MM/YYYY')
• and then use of "numerical value" filter for it as it will have only single value for all days
• or use of "evaluate value" where formula can be used to return single numerical value.

Cheers

[Lech_Miszkiewicz · Accepted solution]

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

https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/ReportsDevelopment/Static-dynamic-fi...

[DiegoF]

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!

[Lech_Miszkiewicz]

Yes - that can work, just remember that advanced search will only filter values within current selection if other filters are applied.