Remove the -

[pgalvezt]

Hello,

I´ve created a new column where I have to count a lot of documents. Into of these documents some information appears with the caracter - .

for example DOC  COUNTRY  RESULT(COUNT)

                    1          COL            1

                    2          ARG            1

                    3          BR               -

                    4          ESC             -

                    5          ALE              1

Then,

How can I remove the cells with - into my formula?

Thanks.

[sushil353]

Hi,

It is simple.. change the null  and missing symbole accordingly.. you can make that to 0 or as your wish.

[pgalvezt]

I tried with " ". But I obteined this:

The row still keep appearing.

[#4]

If you want nothing, then

In the Presentation tab for the chart, Null Symbol - Erase everything and leave it empty.

If you want 0, then type in 0 there.

[#5]

Hi,

Did you find a solution for this?

I am also experiencing the same problem.

[pgalvezt]

Hi, seem that QlikView doesn´t have this option. I try with deleted when the value is null and nothing. On the presentation tab you just can change the way how to show values null. If anybody knows how to deleted the "-" please share the information with us.

Thanks!

[kaushiknsolanki]

Hi,

   Will you upload your file, that will help us to understand your problem properly.

Regards,

Kaushik Solanki