Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
Not applicable

How can I set value to zero

How can I set empty value to zero value in pivot table expression.

(1-num([EKSTRA İSKONTO],'#.###'))

I try if statement but I cant fix.

if column is empty, return all expression zero.

I want to return zero [EKSTRA İSKONTO] if its empty.

Tags (2)
1 Solution

Accepted Solutions

Re: How can I set value to zero

May be like this:

1 - If(Len(Trim([EKSTRA İSKONTO])) = 0 , 0, [EKSTRA İSKONTO])

View solution in original post

1 Reply

Re: How can I set value to zero

May be like this:

1 - If(Len(Trim([EKSTRA İSKONTO])) = 0 , 0, [EKSTRA İSKONTO])

View solution in original post