Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

viveksingh
Contributor II

Convert zero to number and right allign

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.

Tags (1)
1 Solution

Accepted Solutions
viveksingh
Contributor II

Re: Convert zero to number and right allign

I Got it. Used replace()

View solution in original post

1 Reply
viveksingh
Contributor II

Re: Convert zero to number and right allign

I Got it. Used replace()

View solution in original post