Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
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.
regards
Pradosh
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!