topic Re: Calculated Expression Label in Excel Report? in Qlik NPrinting

Calculated Expression Label in Excel Report?

mikecrengland — Wed, 11 Nov 2015 18:05:38 GMT

Hello all -

I have a straight table that has expressions for the column labels. The table shows a rolling 13 weeks.

The expression that builds the column labels is:

=Date(Only({1<Cal.RelativeWeek = {'-13'}>} Cal.WeekStartMon),'MMM-DD')

When I add the columns from the table to the Template editor and preview the report, the column headers come through as the text of the expression rather than the result.

How do I get the column labels to calculate?

Thanks!

mike

Re: Calculated Expression Label in Excel Report?

Wed, 11 Nov 2015 18:58:30 GMT

when you refer to the tempalte editor are you referring to NPrinting?

Re: Calculated Expression Label in Excel Report?

mikecrengland — Wed, 11 Nov 2015 18:59:04 GMT

Yes

Re: Calculated Expression Label in Excel Report?

Wed, 11 Nov 2015 19:01:23 GMT

you will not be able to do it that way

I am going to attach a link in a minute that may help you - it is building a NPrinting report going back 6 months and is calcualting the date - you will need to do this in NPrinting

I believe you will need to crate dynamic filters and also create variables - the filters will limit the data to your timeframe and the variables will be used to get the data for the column

How to Create QlikView Bookmark Filters Using Dynamic Search Expressions – Customer Feedback for Vizubi

How to Create Static and Dynamic Filters Based on Fields – Customer Feedback for Vizubi

How to Report Sales for the Six Months Previous to This One – Customer Feedback for Vizubi

Ability to dynamically email recipients based on a QlikView field or variable – Customer Feedback for Vizubi

Allow NP formulas to be used in Excel text boxes – Customer Feedback for Vizubi

Re: Calculated Expression Label in Excel Report?

mikecrengland — Wed, 11 Nov 2015 19:22:35 GMT

Thanks, Adam.

I ended up just creating 13 QlikView variables in the document that were the label expressions and then used the variables as the column headers in the NPrinting template.

mike