topic Re: If else in Excel N printing in Qlik NPrinting

If else in Excel N printing

pradosh_thakur — Wed, 20 Jun 2018 10:16:55 GMT

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_thakur — Wed, 20 Jun 2018 10:17:42 GMT

Stephen_Jasionowski — Wed, 20 Jun 2018 10:21:29 GMT

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

pradosh_thakur — Wed, 20 Jun 2018 10:34:58 GMT

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.

Stephen_Jasionowski — Wed, 20 Jun 2018 12:03:21 GMT

We are planning .xlsm support for September.

Lech_Miszkiewicz — Thu, 21 Jun 2018 02:23:17 GMT

Agree with Stephen. Your conditional approach will not work!