This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration on Qlik NPrinting.
I was working with Excel N printing and i need to apply if else condition.
show there is a on demand task which is responsible for downloading few excel reports. CH01,CH02,CH03 are the chart id.
so i wanted to write a condition like if(condition,<CH01>,<CH02>) -> Throws error.
i used indirect function with concatenate in excel but it just prits the chart id in the output.
i used the formuas option and it also prints the chart id but not the data.
Any help and suggestion is much appreciated.
Pradosh - there is no conditional show/hide for Office reports. I suggest using PixelPerfect for this use case: https://help.qlik.com/en-US/nprinting/April2018/Content/PixelPerfectReports/Manage-Conditional.htm
I need to do this in Excel Reports which was using macro to do the same before so pixel perfect is not an option for me.
We are planning .xlsm support for September.
Agree with Stephen. Your conditional approach will not work!