Discussion board where members can get started with QlikView.
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.
Go to Solution.
Yes, it worked :).