Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
edemerdjieva
Partner - Creator
Partner - Creator

Equivalent of NVL() in QlikView

Hi all,

I have two sets of data which relate to each other 1:N.

An item appears only one time in set A (item_id, amount A) and can appear several (N) times in set B (item_id, amount B). The link between the two is item_id (unique).

In some cases there is only data in Set A and nothing in Set B (see image attached). In Oracle I would use NVL() function so that KPI based on Amount B has a value 0.

What is the equivalent of NVL() in QlikView ? In the example given in the screenshot the item 'BB' should be present in the chart.

 

Thanks a lot for your help.

Labels (2)
1 Solution

Accepted Solutions
sunny_talwar

May be try the Alt() function.... Alt(Sum(Amount Set B), 0)

View solution in original post

2 Replies
sunny_talwar

May be try the Alt() function.... Alt(Sum(Amount Set B), 0)
edemerdjieva
Partner - Creator
Partner - Creator
Author

Yes, it worked :).

 

Thanks!