topic Re: to Exclude Particular Record in QlikView

to Exclude Particular Record

SatyaPaleti — Thu, 07 Jan 2016 08:46:26 GMT

Hi Friends,

I am having field called 'Name'

Record in the Name are Spell-Teleca,Spell-Indica,,Spell_Spanish,Spell-godrey,Spell-Inter

My requirement is

I want to show all the records in Name field Except Spell-Indica

Can i use Not match function

I am using Not Match(Name,'Spell-Indica') but it's not working can any one help to resolve this issue

THank You,

Satya

Re: to Exclude Particular Record

Chanty4u — Thu, 07 Jan 2016 08:50:52 GMT

1. Add Calculated Dimension

if(Not WildMatch([Spell], 'Teleca_*', 'Indica_*', 'Spanish_*'),[Spell])

2. Check "Supress when value is null"

try abve

Re: to Exclude Particular Record

Chanty4u — Thu, 07 Jan 2016 08:52:24 GMT

chk below link

How to exclude the field values?

Re: to Exclude Particular Record

tamilarasu — Thu, 07 Jan 2016 09:08:38 GMT

Try,

If(Not Match(Name,'Spell-Indica'),Name)

Re: to Exclude Particular Record

Thu, 07 Jan 2016 09:18:13 GMT

if(name<>'Spell-Indica',Name)

Re: to Exclude Particular Record

Peter_Cammaert — Thu, 07 Jan 2016 09:23:51 GMT

For straight tables and all objects that perform some kind of aggregation, use set analysis. You'll get better performance. For example, an expression like

=sum({<Name -= {'Spell-Indica'}>} Sales)

won't calculate results for value 'Spell-Indica' and because NULL values are suppressed by default, will not show the row for that value.

Re: to Exclude Particular Record

HirisH_V7 — Thu, 07 Jan 2016 09:24:08 GMT

Hi,

=If(Name='Spell-Indica',Null(),Name)

Supress Null Values for your Dimension

HTH,

Hirish

Re: to Exclude Particular Record

ahmar811 — Thu, 07 Jan 2016 09:26:06 GMT

try this

if(wildmatch(Name,'Spell-Indica')=0,Name)

hope this help you

Thanks & Regards

Ahmar Ansari

Re: to Exclude Particular Record

panipat1990 — Thu, 07 Jan 2016 09:38:51 GMT

Hi Satya,

Try This

Load

Name

From

(ooxml, embedded labels, table is Sheet1)

Where Name <> 'Spell-Indica';

Re: to Exclude Particular Record

HirisH_V7 — Thu, 07 Jan 2016 10:04:15 GMT

I agree with pcammaert go with set analysis exclusion for better performance of your report .

-Hirish

Re: to Exclude Particular Record

SatyaPaleti — Thu, 07 Jan 2016 10:27:26 GMT

Hi friends,

Thank you for your Replies,

Actually My Requirement is I am having Field(Name) with records

Teleca Inter-ship, Max Inter-ship, Min Inter-ship, Teleca Exchange, Max Exchange, Min Exchange

I want to exclude Names which have Inter-ship

Thank you,

Satya

Re: to Exclude Particular Record

tamilarasu — Thu, 07 Jan 2016 10:29:47 GMT

Try,

If(Not WildMatch(Name,'*Inter-ship*'),Name)

Re: to Exclude Particular Record

PradeepReddy — Thu, 07 Jan 2016 11:33:47 GMT

try like this..

assuming you are loading data from Database..

SQL

select *

from table1 where NAME not like '%Inter-ship%';

Re: to Exclude Particular Record

Peter_Cammaert — Thu, 07 Jan 2016 12:20:47 GMT

Again, using set analysis:

=sum({<Name -= {'*Inter-ship'}>} Sales)

Re: to Exclude Particular Record

panipat1990 — Thu, 07 Jan 2016 12:36:06 GMT

Load

Name,

If(TextBetween(Name, '-','')='ship' ,Null(),Name)As New_Name

From

(ooxml, embedded labels, table is Sheet1);

Load

Name

//If(TextBetween(Name, '-','')='ship' ,Null(),Name)As New_Name

From

(ooxml, embedded labels, table is Sheet1)

Where TextBetween(Name, '-','')<>'ship';

Re: to Exclude Particular Record

panipat1990 — Fri, 08 Jan 2016 05:11:47 GMT

Hi,

Try This

Load

Name,

If(SubStringCount(Name,'Inter-ship')=0,Name) As New_Name