topic Re: dynamic report name in nprinting excel reports in Qlik NPrinting

dynamic report name in nprinting excel reports

Thu, 31 Mar 2016 09:15:13 GMT

Hi,

I tried to provide a dynamic to the excel report in NPrinting using Qlikview variable. But the variable cannot be evaluated and it returns the same expression as the result.

ex: I have created a variable for Maximum available Year as below.

vMaxYear=Year(Max(Ref_Date))

The same variable is being referred in the report name and The report name appears as Report_Year(Max(Ref_Date)).

But it should be displayed as Report_2016.

Could you please assist me how to achieve this and let me know where I am going wrong?

The screenshot is attached

Thanks,

Ramesh.

Re: dynamic report name in nprinting excel reports

Anonymous — Thu, 31 Mar 2016 12:03:22 GMT

The display will show the variable name in the preview as the variable description. When you run a task with this report, does it not show the actual variable in the name?

I just added a variable to my QV app and called it vShow. I assigned a value in my variable overview and then went and added it to my dynamic naming. When I run the task, the variable shows up as evaluated in my report name.

You will not get the dynamic name when creating a preview.

To test, you could create a text box in your qv app and see what the result is of your variable

Re: dynamic report name in nprinting excel reports

Thu, 31 Mar 2016 12:43:47 GMT

Hi Mike,

Thanks for your help. The issue is resolved now. The issue is because of the date displaying as 3/2/2016. It gives a message 'Invalid characters in a file name" because of Slash Symbol '/' present in the date.

Now I have modified as 3-2-2016 and it works now.

Again I would like to say thanks for spending your valuable time.

Thanks,

Ramesh.

Re: dynamic report name in nprinting excel reports

Fri, 01 Apr 2016 11:08:32 GMT

Hi Mike,

Is there any way that we can capture the filter that we are applying for the report to the report name?

Your suggestion is appreciated.

Thanks,

Ramesh.

Re: dynamic report name in nprinting excel reports

Anonymous — Fri, 01 Apr 2016 12:19:03 GMT

In the Dynamic Names, you can choose Custom Text and pretty much put whatever you want. For example, say I want a salesman as my filter. I would precede a variable item with a custom text that said 'Salesman ' and the variable in the next item would add the Salesman name.

This is a little less dynamic, but doable for your needs. If you have a lot of filter fields, it might be cumbersome.

Re: dynamic report name in nprinting excel reports

Fri, 01 Apr 2016 13:17:13 GMT

Hi Mike,

I need dynamic name for my report based on filter applied to the report.

Say, I am applying a date filter 3-30-2016 to my report 'Report'. The report name should be 'Report_3-3-2016'.

Thanks,

Ramesh.

Re: dynamic report name in nprinting excel reports

Stephen_Jasionowski — Fri, 01 Apr 2016 13:58:26 GMT

Ramesh -

If the date filter is part of a cycle, you can include the cycled dimension value as part of the dynamic name.

The date that is offered as part of the dynamic naming in NPrinting refers to the date the report is generated.

In this case, you can create another QV variable for the selected date and add that variable to the dynamic name in addition to the one you are already using.

Re: dynamic report name in nprinting excel reports

Tue, 05 Apr 2016 10:20:40 GMT

Hi Stephen,

I was able to do it now. Thanks a lot for your help.

Thanks,

Ramesh.