Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

I want Exclude particular sort of values from list box

Hi guys,

In one field  i have data like   144954/78768/fds

                                           133454/46567/klh

                                            23545/67676/lkg

                                            ******/*****/erd

                                            *****/***** /lkj

                                            ***********jmh

                                            ***********hng

So in the above field values i want to remove * field values in the field.

So can anyone tell me how to exclude those field values completely from that particular field.

by using set analysis or not widlmatch anything but i need a solution guys...

thanking you in advance!

Message was edited by: vijay krishna

1 Solution

Accepted Solutions
tamilarasu
Champion
Champion

Try,

=Sum({<Field={"=Index(Field,'*')=0"}>}cost)

View solution in original post

11 Replies
MK_QSL
MVP
MVP

Do you want to exclude Last Two fields from Script or in any chart/table?

avinashelite

try like this

if(field_name<>'*/*',filed_name)

tamilarasu
Champion
Champion

Hi Vijay,

Try,


If(Index(Field,'*')=0,Field)

Load script can be

Load If(Index(Field,'*')=0,Field) as Field

...

From Source Data.

Not applicable
Author

ya i want to remove all the field values where * is in that field value....

MK_QSL
MVP
MVP

In script you can ignore field using below

Data:

Load * Inline

[

  FieldName

  144954/78768/fds

  133454/46567/klh

  23545/67676/lkg

  ******/*****/erd

  *****/***** /lkj

  ***********jmh

  ***********hng

]

Where Index(FieldName,'*')=0;

aveeeeeee7en
Specialist III
Specialist III

Hi Vijay

Try SubstringCount() Function.

See this:

TABLE_1:

LOAD * INLINE [

NUMBER

144954/78768/fds

133454/46567/klh

23545/67676/lkg

******/*****/erd

*****/***** /lkj

] WHERE SubStringCount(NUMBER,'*')=0;

Regards

Av7eN

Not applicable
Author

it's  working ok by using if condition and index function....

can you do it in set expression also

like this

sum({<Field-={'%*%'}>}cost)

Please give correct answer using set expression also

tamilarasu
Champion
Champion

Try,

=Sum({<Field={"=Index(Field,'*')=0"}>}cost)

HirisH_V7
Master
Master

Hi,

May be like this in both front end and back end,

Data:

LOAD *,

If(Mid(Field,1,2)='**',Null(),Field) as Field2


INLINE [

    Field

    144954/78768/fds

    133454/46567/klh

    23545/67676/lkg

    ******/*****/erd

    *****/***** /lkj

];

In list box expression:

=If(Mid(Field,1,1)='*',Null(),Field)


Exclude Field records -214031.PNG

HTH,

PFA,

Hirish

HirisH