Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

dadumas
Contributor

Can NPrinting Cycle a Report based on a list box expression values

Note, the listbox displayed values are based on an expression:

This below is a sample expression that displays the desired items in the listbox, based on the sheet that I am on in qlikview:

=if(aggr($(vBridgeHours_DurationHours),[Device Name])>0,[Device Name])

This works great, and only populates the listbox with [Device Name] items that are relevant on that sheet.

So, while the the listbox is based on an expression, it is populated from a field in the data model, in this case :  [Device Name].


However, I cannot simply cycle all [Device Name] items because not all devices will meet the criteria in the expression above, which, again, is based on the sheet that I am on in qlikview.




Tags (1)
5 Replies
lironbaram
Honored Contributor II

Re: Can NPrinting Cycle a Report based on a list box expression values

hi

you have two option here

to apply a filter on the device name field in the nprinting report that will select only the relevant  devices for the report

than the cycle will only use those values

you'll need to use evaluate type of filter , that can process qlik expressions

dadumas
Contributor

Re: Can NPrinting Cycle a Report based on a list box expression values

I am not familiar with an evaluate filter - can you explain a bit more?

lech_miszkiewic
Honored Contributor III

Re: Can NPrinting Cycle a Report based on a list box expression values

Hi,

You can calculate this condition in Qlik script and flag devices with required condition. Then you can cycle normaly through device filed with filter applied on your condition flag.

that is my favourite approach which proves to be stable and working as it should.

regards

Lech

dadumas
Contributor

Re: Can NPrinting Cycle a Report based on a list box expression values

Unfortunately, script to add flags in the data model during load will not work.  The devices are dynamic, based on several factors. 

Employee
Employee

Re: Can NPrinting Cycle a Report based on a list box expression values

Please check the help site page Static and dynamic filters ‒ Qlik NPrinting

Community Browser