topic Re: Create Filter by using Calculated Dimension on N-Printing in Qlik NPrinting

Create Filter by using Calculated Dimension on N-Printing

EGDR — Mon, 26 Jun 2023 14:57:17 GMT

Hi Friends,

Help me on this Query

I am trying to create country filter in Qlik N-Printing, by using Calculated dimension from the Qlik Sense

Pls find expression on Qlik Sense, creating filter By using the same Expression on N-Printing, Tried "Advanced search", "Numeric value", But not working, while click on preview we are getting Error message.

Example:

=if([ID]='ABC 42' or [ID]='ACD 43',if([Country]<>'_ABCD' and Country<>'_CDDE',Country),

IF( Region = '_gfghf'
, ' ' & Country & ' TOTAL'
, IF([Country] = '_REGION'
, [Region] & ' TOTAL'
, if(Country = '_ABC'
, 'ABC TOTAL'
, [Country]
)
)
)
)

Re: Create Filter by using Calculated Dimension on N-Printing

Zapparoli — Mon, 26 Jun 2023 15:05:45 GMT

Hi @EGDR!

Nprinting does not work properly with calculated dimensions.

In your case, move this calculated dimension to your load Script and it should work properly.

-Zapparoli

Re: Create Filter by using Calculated Dimension on N-Printing

EGDR — Mon, 03 Jul 2023 11:38:51 GMT

Hi @Zapparoli , As you mention, I created field in back end and tried used in filter, but not working

Re: Create Filter by using Calculated Dimension on N-Printing

Zapparoli — Mon, 03 Jul 2023 12:23:00 GMT

Hi, @EGDR ,

Can you share some Print screens of the Nprinting where you are creating the filter ?

Re: Create Filter by using Calculated Dimension on N-Printing

Lech_Miszkiewicz — Mon, 03 Jul 2023 14:20:25 GMT

Hi @EGDR ,

You say you have created it in load script (when you say back-end) and created it as a field. Please share:

Screenshot that field preview in Qlik Sense data model viewer so we can see its datatype and values
Screenshot how you are trying to create a filter in NPrinting
Let us know if there are any other filters you are using

Also - is your Qlik app supported. Filter issues may be related to fact that you may have always one selected values, or sheet triggers or other unsupported objects which you can find all detailed on https://help.qlik.com.

for example:

https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/GettingStarted/HowCreateConnections/Connect-to-QlikSense-apps.htm

Thanks

Lech

Re: Create Filter by using Calculated Dimension on N-Printing

EGDR — Mon, 10 Jul 2023 09:27:38 GMT

Hi @Lech_Miszkiewicz ,

created the below dimension and load the data which in turns saves it in a QVD format.... now when we are using the QVD, this Dimension should be considered as a fact data.... however N-Printing is still not picking this up

Data Load Editor:

Example:

=if([ID]='ABC 42' or [ID]='ACD 43',if([Country]<>'_ABCD' and Country<>'_CDDE',Country),

IF( Region = '_gfghf'
, ' ' & Country & ' TOTAL'
, IF([Country] = '_REGION'
, [Region] & ' TOTAL'
, if(Country = '_ABC'
, 'ABC TOTAL'
, [Country]
)
)
)
)

Re: Create Filter by using Calculated Dimension on N-Printing

Lech_Miszkiewicz — Mon, 10 Jul 2023 10:45:18 GMT

Hi @EGDR

This is very basic step - you clearly are doing something very wrong and you are not providing us with all steps to replicate your issue. I mentioned before the minimum we need (screenshots of what you are experiencing) so I guess we will wait until you provide us with what we need to diagnose what you do wrong.

Otherwise I am sorry but we will not be able to help you.

cheers