topic Re: Eliminate blanks from front end in QlikView

Eliminate blanks from front end

qlikviewwizard — Mon, 25 May 2015 06:41:35 GMT

Hi All,

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

How to achieve this?

Thanks in advance.

danieloberbilli — Mon, 25 May 2015 06:44:05 GMT

e.g.

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

PrashantSangle — Mon, 25 May 2015 06:45:18 GMT

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 — Mon, 25 May 2015 06:50:28 GMT

timanshu — Mon, 25 May 2015 07:01:12 GMT

Do:

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

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

Mon, 25 May 2015 07:46:58 GMT

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 .