topic Re: Help me to fix null value in Straight table in QlikView

Help me to fix null value in Straight table

karan_kn — Wed, 25 Nov 2020 16:16:04 GMT

Please help me to fix null value. Attached QVW and excel for your reference.

Re: Help me to fix null value in Straight table

sunny_talwar — Fri, 06 Apr 2018 16:06:28 GMT

May be using this

=If(ID = Above(TOTAL ID), Null(), Name)

Re: Help me to fix null value in Straight table

vishsaggi — Fri, 06 Apr 2018 16:18:52 GMT

may be another way like

Table:
LOAD *
WHERE DupId = 1;
LOAD ID,
IF(ID = Previous(ID), 0, 1) AS DupId,
Name,
Country
FROM
TestNull.xlsx
(ooxml, embedded labels, table is Sheet1);