Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

sowmiya23
Contributor

Condition in nprinting

I have a filed as Start date in Qlivkiew applciaiton, while automating Nprinting report i need data only for 180 days from today..

How to do that in Npritning and how to include that in while automating repots

1 Solution

Accepted Solutions

Re: Condition in nprinting

Hi Soundarya, I think the easier way is flag this records in script, in calendar table, or in fact table if there is no calendar.

This field can be used as filter for the report, ie:

LOAD ....

     If(Today()-DateField<=180, 1, 0) as isLast180Days

...

And set a filter in NPrinting like isLast180Days=1

6 Replies

Re: Condition in nprinting

Hi Soundarya, I think the easier way is flag this records in script, in calendar table, or in fact table if there is no calendar.

This field can be used as filter for the report, ie:

LOAD ....

     If(Today()-DateField<=180, 1, 0) as isLast180Days

...

And set a filter in NPrinting like isLast180Days=1

sowmiya23
Contributor

Re: Condition in nprinting

Once the Usage date gets selected i want to use many filter conditions at the time of Importing recipient..

Is that possible ?

(i.e) only after selecting the 180 days usage date the next filer has to be applied

. will that work in that way ?

sowmiya23
Contributor

Re: Condition in nprinting

Also where  do u set  isLast180Days=1 in Nprinting. There is only two selection like is numeric and evaluate.. Where to specify this condition. is it possible to attach a screenshot

Chanty4u
Esteemed Contributor III

Re: Condition in nprinting

Elaluvate you can use.

number you can use when the values like   Year  ,month,day like that number values

Re: Condition in nprinting

Hi Sorundarya, sorry for delay. I don't fully understand the requirements, also I haven't done many recipient imports so most probably I don't know how to do it.


Is this for NPrinting 16?

sowmiya23
Contributor

Re: Condition in nprinting

Yes it is Nprinting 16

Community Browser