Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
pradosh_thakur
Master II
Master II

If else in Excel N printing

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

Learning never stops.
5 Replies
pradosh_thakur
Master II
Master II
Author

lech_miszkiewiczsjw

Learning never stops.
Stephen_Jasionowski

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
Master II
Master II
Author

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.

Learning never stops.
Stephen_Jasionowski

We are planning .xlsm support for September.

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Agree with Stephen. Your conditional approach will not work!

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.