Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlik expert,
I'm creating multiple filters and users using the Excel upload feature available, under the Filter table in the excel template provided in nPrinting Template link, where do I put in formula of my field? and ideally how should the formula look (especially if set analysis is involved.
Also for Filters would creating multiple fields within a filter work on excel and is there any example I can refer to?
Hi @Keitaru
there you go:
You just populate the syntax as documented in the line where you create filter.
Were you doing it like that?
cheers
Lech
Hi @Keitaru
1. Have you studied documentation on https://help.qlik.com ? That needs to be always your first reference - have you done that already?
If you did - you would be going thorugh this: https://help.qlik.com/en-US/nprinting/February2024/Content/NPrinting/DeployingQVNprinting/Import-Use...
Lastly, please be precise when formulating your question:
Critical thing here is to identify type of the filter you are applying (marked red above)!
more about filters on my blog: https://nprintingadventures.com/category/nprinting/filters/
Yes I have looked at the help and even watched a few youtube videos read a few of the forum post but didn't see exactly how it has been done. That's why i'm asking it in here.
Ok that is fair enough but it still does not answer my question regarding what type of filter are you trying to apply? I marked it in red in my previous post as that must be starting point before we go any further in the discussion. I also put below here the equivalent screenshot directly from NPrinting.
Each of the options highlighted below works differently, has dedicated usecase and requirements and supports certain data types in Qlik data model. I also mentioned that each of those options is represented in import template by separate column which is obvious when you look at it.
So once again - what type of filters are you trying to create import for?
cheers
Hi @Lech_Miszkiewicz ,
Trying to create multiple filters with 2 values each.
This is to be tagged to various different users which would be in a group for us to send out monthly reports on from our targeted QV app.
2 Fields within filter.
Hi @Keitaru
there you go:
You just populate the syntax as documented in the line where you create filter.
Were you doing it like that?
cheers
Lech
Yes, was quite confused by the columns and the relations to the drop down selection.
Thank you for the detailed example.
Great we could help although I will just say it again - it is all in https://help.qlik.com very well explained:
each column with what it does.
cheers