Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 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
Allow NP formulas to be used in Excel text boxes – Customer Feedback for Vizubi
when you refer to the tempalte editor are you referring to NPrinting?
Yes
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 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
Allow NP formulas to be used in Excel text boxes – Customer Feedback for Vizubi
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