topic Re: Using set analysis for a dimension for N printing in Qlik NPrinting

Using set analysis for a dimension for N printing

Wed, 17 May 2017 15:51:41 GMT

I have a document which has 'Always one selected value' in a list-box that contain dates. I am using Nprinting to generate reports and hence want to create a straight table that contains data for the last 7 days, I cannot use alternate states/triggers as these do not work with N printing. What would be a good work-around. I tried set analysis, but that wont work too as there is no expression, I tried

=only({<[Report Date]=>}[Report Date]) but this gives me //Error in calculated dimension.

Re: Using set analysis for a dimension for N printing

sibusiso90 — Wed, 17 May 2017 16:43:14 GMT

Try using it as an expression, instead of a calculated dimension. With a straight table you need to have. An expression to use it. Can you also give a sample sinaro so that I can work on it as well.

Re: Using set analysis for a dimension for N printing

Anil_Babu_Samineni — Wed, 17 May 2017 16:52:53 GMT

What are you trying to achieve by help of Calc. Dimension?

Re: Using set analysis for a dimension for N printing

Daniel_Jenkins — Wed, 17 May 2017 23:22:17 GMT

Hi Divvya,

What version of NPrinting?

If using version 16.x and earlier - you will need to un-check Always One Selected Value from the list box properties as it is not supported. Once that is done (and also if using version 17.x ) - build and use a filter to simulate the selection you want for field Report Date.

V17.x: https://help.qlik.com/en-US/nprinting/17.3/Content/FiltersCycles/StaticDynamicFilters/Static-dynamic-filters.htm

V16.x: QlikView NPrinting 16 Tutorials - Filters & Cycles

HTH - Daniel.