topic Remove the - in QlikView

Remove the -

pgalvezt — Wed, 17 Aug 2011 17:22:03 GMT

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.

Remove the -

Wed, 17 Aug 2011 18:47:47 GMT

If I understand your issue correctly, the '-' is a null value. On the dimensions tab in Properties, check the 'Suppress When Value Is Null' option.

Remove the -

ToniKautto — Wed, 17 Aug 2011 20:27:47 GMT

If you get null values in your expression column, then you have probably unselected Suppress Zero Values.

Chart Properties > Presentation > Suppress Zero Values

Re: Remove the -

Wed, 17 Aug 2011 21:04:20 GMT

Hello,

When you load in the table you could have it check to see if there is a null value and have it be replaced with a 0.

Regards,
Jeff

Remove the -

pgalvezt — Thu, 18 Aug 2011 18:54:12 GMT

Hi thank you for your answers.

I forgot to say that option is already checked. But only show the option that you want. For example "0".

The row has to dissappear entire. for example the fifth has to disappear. and no change the "-".

Thanks.

Re: Remove the -

Thu, 18 Aug 2011 19:58:22 GMT

Hello,

If none of the information is needed then you can do this in the loading of the table. If the value in the column = null or "-" then don't load in that row. If you want the information to still be there but just with the two fields containing "-" then you would have to do something in a macro such as an onOpen process, I believe.

Regards,

Jeff

Remove the -

pgalvezt — Thu, 18 Aug 2011 20:09:09 GMT

I think that you think that is a dimension column.

But those columns are expressions:

=Date#(Mid(Fecha, 1,9)).

come values gives me a "-".

I tried this but doesn´t work.

=if(Date#(Mid(Fecha, 1,9)) = '-', null(), Date#(Mid(Fecha, 1,9)))

Thanks.

Remove the -

pgalvezt — Thu, 18 Aug 2011 21:16:44 GMT

Any Ideas!

Remove the -

rwunderlich — Thu, 18 Aug 2011 23:05:26 GMT

In the Presentation tab for the chart, change the Null Symbol value to " ".

-Rob

http://robwunderlich.com

Remove the -

swuehl — Thu, 18 Aug 2011 23:15:20 GMT

Even if the appropriate options (like suppress zero values) are checked, the row won't disappear if one of the expressions returns a value >0.

If the first column (the one with all 03-08-2011) is also an expression, the rows are shown, because this column shows a valid value.

So, either move this date column to the dimensions, if possible, or make the expression conditional with regard to output of the other columns.

Besides that, I assume that the other two columns show '-' as indication of NULL. I think it might also be possible that this indicates a non unique return value, i.e. the expression returns more than one value. You could check this e.g. by adding a max() to your expression.

Hope this helps,

Stefan

P.S. In cases like this, it is best if you could post an example showing your issue, it is hard to tell from a screenshot what's going on here.

Remove the -

sushil353 — Fri, 19 Aug 2011 09:45:48 GMT

Hi,

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

Remove the -

pgalvezt — Fri, 19 Aug 2011 14:51:43 GMT

I tried with " ". But I obteined this:

The row still keep appearing.

Remove the -

Fri, 19 Aug 2011 14:58:56 GMT

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.

Remove the -

Mon, 03 Oct 2011 08:44:10 GMT

Hi,

Did you find a solution for this?

I am also experiencing the same problem.

Remove the -

pgalvezt — Mon, 03 Oct 2011 13:10:50 GMT

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!

Remove the -

kaushiknsolanki — Mon, 03 Oct 2011 13:21:18 GMT

Hi,

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

Regards,

Kaushik Solanki