Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

prasadcm
Contributor II

Nprinting 17.1 filters

Hi All,

In my QV file,i have filters like Year,month,currency whose properties say 'Always 1 selected'.

Now i want this filters to be applied to in Nprinting,i created filters using following

d1.png

I also tried max() in evaluate value,but it doesn't work

When i hard code this values,it works fine.

How am i suppose to do ?

gwassenaar

djk

Regards,

Prasad

7 Replies
cesaraccardi
Valued Contributor

Re: Nprinting 17.1 filters

Hi,

Have you tried using Only() instead?

=Only([last year])

=Only([acct month])

=Only([tocurrency])

ramchalla
New Contributor III

Re: Nprinting 17.1 filters

Hi Prasad,

Use max function, check the values for those filters when you run the task and place a screenshot.

prasadcm
Contributor II

Re: Nprinting 17.1 filters

Hi,

I have tried using max function,but data doesn't get filtered.

When we run the task,QV which runs behind shows no selection in filters

Regards,

Prasad

Employee
Employee

Re: Nprinting 17.1 filters

Hi Prasad,

You should not use Always One Selected Value. See this discussion for more information: Re: Nprinting Excel Report Page

HTH - Daniel.

prasadcm
Contributor II

Re: Nprinting 17.1 filters

Hi djk,

I went through that thread,but i have some doubts.

Case 1: If i don't apply any filters & 'Always 1 selected' is present for filters in QV,will data in NPrinting will come according to QV filters?

Case 2: 'Always 1 selected' is present for filters in QV,how am i supposed to get that data in Nprinting by applying or not applying filters in NPrinting?

Case 3: If i want user selected values to replicate in NPrinting,what filters needs to be applied in Nprinting?

Regards,

Prasad

prasadcm
Contributor II

Re: Nprinting 17.1 filters

Hi,

I tried your way,but it doesn't work.

QV which runs behind shows no selection in filters

Regards,

Prasad

Not applicable

Re: Nprinting 17.1 filters

NPrinting does not allow "always one selected value" and will not perform a filter on that specific field.

The only solution I was able to come up with is creating a dummy field on script and having nprinting filter those dummy fields instead of the original one. Also I thing the "only" function works better than "getfieldselections".

Hope it helps.

Community Browser