topic How can we exclude '--' from the data. in QlikView

How can we exclude '--' from the data.

Anonymous — Thu, 29 Sep 2011 10:02:48 GMT

I want to exclude the -- from the given data. Could any one please help me to do this. Its in table and want to exclude in designer part not thru the scripting part. Is this possible to write an expression in designer part which will exclude the -- from the table.

Best Regards,

Shubham

How can we exclude '--' from the data.

kaushiknsolanki — Thu, 29 Sep 2011 10:12:22 GMT

HI,

Try this code.

=purgechar( 'Field_Name','--' )

Regards,

Kaushik Solanki

How can we exclude '--' from the data.

Anonymous — Thu, 29 Sep 2011 10:30:43 GMT

Hi Solanki,

I have tried but it doesn't exclude '--' data from the table. It shows and I want this shouldn't come in to the picture or table. the Entire data should come excluding ''--'' part. FYI.. this is also a field value. Its not a null character.

Best

Shubham

How can we exclude '--' from the data.

jonathandienst — Thu, 29 Sep 2011 10:37:11 GMT

Are you talking about nulls, or fields that contain '--'?

If you want to elimate nulls, it depends on the data source.For example

LOAD field1,

field2

FROM data.xls (biff)

Where Len(field2) > 0;

I think the purgechar way will also remove any single hyphens. You could also use

=Replace(Field1, '--', '')

This will not remove single hyphens.

Hope that helps

Jonathan

How can we exclude '--' from the data.

kaushiknsolanki — Thu, 29 Sep 2011 10:42:33 GMT

Hi,

Then as Jonathan suggested you can use the Replace() Function.

If still it doesnt solve your problem then please upload a sample file.

Regards,

Kaushik Solanki

How can we exclude '--' from the data.

jonathandienst — Thu, 29 Sep 2011 10:44:52 GMT

Do you mean to exclude records with a field containing '--'. Then use

LOAD ....

FROM ....

Where Field1 <> '--';

LOAD ...

FROM ...

Where Index(Field1, '--');

If you are loading via SQL SELECT, then the where clause will depend on your database.

Hope that helps

Jonathan

How can we exclude '--' from the data.

Anonymous — Thu, 29 Sep 2011 11:02:11 GMT

Hi Jonathan,

Thanks for your reply. But only the thing is I wanted to do all this in designer part without touching the scripting. While loading the data it is possible, I know but I want in designer part. Is this possible.??

Best Regards

Shubham Kumar

How can we exclude '--' from the data.

jonathandienst — Thu, 29 Sep 2011 14:15:20 GMT

Shubham

Then you need to be specific about the sheet object(s), dimensions and metrics involved.

Regards

Jonathan

Re: How can we exclude '--' from the data.

kaushiknsolanki — Fri, 30 Sep 2011 05:58:10 GMT

Hi,

Have a look at the example. Hope this will help you.

Regards,

Kaushik Solanki

Re: How can we exclude '--' from the data.

Anonymous — Fri, 30 Sep 2011 08:52:51 GMT

Hi Satish,

Here I am attaching the problem, actually I want to exclude the '--' which is one kind of field in data (table) if you will have a look on the attachemnt, the circled marked need not to be shown there, it should be excluded.

Best,

Shubham Kumar

Re: How can we exclude '--' from the data.

kaushiknsolanki — Fri, 30 Sep 2011 09:36:41 GMT

Hi,

Let us consider that the field contained '--' is Field1.

Now when you take textbox for that field you will see the value '--'.

But to exclude that value you must use the expression listbox (i.e Create a new sheet object -> listbox -> properties- >fields -> select Expression.

Type

=if(Field1 <> '--',Field1)

Same way you should use the expression in chart if you use that field in chart.

Regards,

Kaushik Solanki