Qlik N-printing Condition - Only generate the report when today is equal to Last 10 Working Days

[rastogi_vinayak]

Hi MVP/All,

Requirement: Generating the Report on Every Month last 10 Working Days only that will be so for achieving this I'm using the Qlik N-printing Condition

What I'm doing for achieving this scenario:  I was created two variable and then compare both the variables on Qlik N-printing  condition Side (Screen Shot Below)

if(NetWorkDays(TempDate, TempDate)>0, Date(date#(TempDate, 'M/D/YYYY' ))) as WorkDay

if(WorkDay >= MonthEnd(WorkDay)- 10 and WorkDay < MonthEnd(WorkDay), WorkDay) as last_10_WorkDay

vDate: =Day(TODAY()) ---> value of variable is 24 

vEndof10Day: =Day(Date(Max(last_10_WorkDay), 'M/DD/YYYY')) ----> value of variable is 24 

then I Compare the both variable on Condition side (See below Screen Shot)

But Still not works & shows error "Conditions evaluated to false for task" at task execution time.

Ref Video link Generating a report every end of the month - Qlik NPrinting: https://www.youtube.com/watch?v=6u6bTssJBM8

Please help me out on this.

Thanks,

Vinayak Rastogi

[Frank_S]

HI @rastogi_vinayak

I suggest that you test the expressions used for each variable in your Qlik Sense dashboard and ensure they are yielding the correct information.

Kind regards...

[Ruggero_Piccoli]

Hi,

I agree with @Frank_S 's suggestion. I prefer to remove the condition and print all used variables temporally  in the template and run the task. So you can check the values used during the report generation.

Best Regards,

Ruggero

[Lech_Miszkiewicz]

My observations:

1 - how do you set your variable values?

• in script?
• in UI
  • do those variable expand? - do they have "=" sign in front of formula in variable definition
  • or do you just put formula in variable definition (without "=" sign"

2. - second issue might be related to the fact that your variable may not update after reload and metadata refresh may be required -  (quite unusual scenario but arguably for me this is the "area of unknown" which I still want to open support ticket about but have to build a case first: https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Task-does-not-refresh-filter-variable-prope...

cheers

Lech