Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
priyarane
Specialist
Specialist

0 Missing

Hi Community,

0 is missing as attached possible value is 0% only.

0 missing.PNG

Labels (1)
12 Replies
jagan
Partner - Champion III
Partner - Champion III

Hi Balraj,

If there is null value Alt function will return the second parameter.  For example

Alt(CLOSED_DATE, Today())

If CLOSED_DATE is Null then Alt() will return Today's date.

Hope this helps you.

Regards,

jagan.

Anonymous
Not applicable

Okay, so it handles null values. If Closed_Date is null then Today() is the alternate value of it...

jagan
Partner - Champion III
Partner - Champion III

Yes.  Similar NVL() in oracle.

Regards,

Jagan.