topic I want to use the variable value as a pivot table column header in Qlik Automate

I want to use the variable value as a pivot table column header

selvakumara — Mon, 17 Feb 2025 20:32:00 GMT

Team,

I want to use Qlik Sense variables as column headers in an NPrinting Excel pivot table. But it' s not working properly.

Thank you.

Re: I want to use the variable value as a pivot table column header

JandreKillianRIC — Tue, 18 Feb 2025 06:30:22 GMT

Hi @selvakumara
In Qlik I would just add the variable like this.

= '$(vTestCol)'

This should then work in NPrinting.

Regards Jandre

Re: I want to use the variable value as a pivot table column header

selvakumara — Tue, 18 Feb 2025 16:21:24 GMT

I used the variable like above and I got the date is coming up correctly in Qlik sense. But When I try to use Nprinting It's not showing correctly. Emp Join Date I want to display the variable values as header value