topic Re: Need to remove duplicate record in QlikView

thanks

Tue, 30 Jul 2013 10:20:00 GMT

Thanks

Tue, 30 Jul 2013 10:27:37 GMT

do u want remove the data from chart?

if yes, then create the calculated dimension instead of name dimension in chart.

if(Right(Name,4)<>'n.a.',Name)

do u want remove the data in script part?

Load * from ur table

where Right(Name,4)<>'n.a.';

Regards,

Kabilan K.

Tue, 30 Jul 2013 10:32:33 GMT

already tried dude , but not working ...
unfortunately getting nulls in the report .

somenathroy — Tue, 30 Jul 2013 10:34:42 GMT

You may try below where with LOAD statement:

Where SubStringCount(Name,'n.a.')=0;

Regards,

som

Tue, 30 Jul 2013 10:39:22 GMT

Hi Satti,

You can use below where clause. Hope your problem will be solve.

where not wildmatch(NAME,'n.a.*')

Thanks

Garry