Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Partner
Partner

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

Re: Equivalent of NVL() in QlikView

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

Re: Equivalent of NVL() in QlikView

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

Re: Equivalent of NVL() in QlikView

Yes, it worked :).

 

Thanks!