Eliminate blanks from front end

[qlikviewwizard]

Hi All,

I want eliminate NULL values ('-') from the from end report.

How to achieve this?

Thanks in advance.

Dept	Ename	EMPNo	SAL
10	Ename1	EMPNo1	1,000.00
10	Ename2	EMPNo2	20,000.00
10	Ename3	EMPNo3	1,000.00
20	Ename4	EMPNo4	20,000.00
20	Ename5	EMPNo5	1,000.00
20	Ename6	EMPNo6	50,000.00
20	Ename7	EMPNo7	1,000.00
20	Ename8	EMPNo8	20,000.00
20	Ename9	EMPNo9	1,000.00
20	Ename10	EMPNo10	20,000.00
20	Ename11	EMPNo11	1,000.00
20	Ename12	EMPNo12	50,000.00
30	Ename13	EMPNo13	1,000.00
30	Ename14	EMPNo14	20,000.00
30	Ename15	EMPNo15	1,000.00
-	Ename16	EMPNo16	20,000.00
-	Ename17	EMPNo17	1,000.00

[danieloberbilli]

e.g.

load * resident where len(trim(Dept))>0;

[PrashantSangle · Accepted solution]

Hi,

Select Chart -> Straight Table -> Add dimension

Dept, Ename,EmpNo

Expression Sum(Sal)

In Dimesnion Tab-> Select Dept ->and check supress When Null

Regards

[qlikviewwizard]

Thank you dreamer4 and danieloberbillig

[timanshu]

Do:

1 )In Dimensions tab, mark  "suppress when value is null".

2)In presentation, mark "suppress missing" and "suppress missing values"

[#6]

Same:

1> In Straight table: check "suppress when value is null" in Dimensions tab.

2> check "populate missing  cells" And clear '-' from null symbol and missing symbol .