Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I want to replace null nd missing values with zero nd convert it into number.
I Have changed this in presentation tab, it is working fine in Qlikvie. But when I export ti excel, zero is alligning to left as text.
I Want it to be as number and right alligned.
Actually, the field doesnot have any zero values. But when I count the field on dates for few of the dates it doesnot have any value. So I’m replacing the mussing and null with zero. Now I want the zero value to be right alligned as nunber when exported to excel.
I Got it. Used replace()
I Got it. Used replace()