Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

fmazzarelli
Contributor III

EXCLUDE DATA

hI Community,

my data are organized as below

Colum1

SE/1

SE/2

SE/3

SE/4

ORD/5

SE/6

ORD/7

I need to exclude ORD records not in loader script but in the user interface

I create a table

I add a column called Order

I need to exclude all the records starting with ORD/

How I could do it?

Thanks

Fabio M

4 Replies
MVP
MVP

Re: EXCLUDE DATA

This won't be possible in a table box, but in a straight table you can add an expression like this:

If(not WildMatch(Column, 'ORD*'), Column)

or you can also use set analysis if Column is your dimension

{<Column -= {'ORD*'}>}

Re: EXCLUDE DATA

Create a flag in script

if(wildmatch(lower(Column),'ord*'),0,1) as Flag


Now in Expression use this flag


=Sum({<Flag ={'1'}>}Value)

MVP
MVP

Re: EXCLUDE DATA

A front end calculation or calculated dimension is the simplest solution (as per SunnyT), but may not perform well in a large data set. In this case, setting a flag and use a set expression to exclude the ORD values will perform better (as per Kush)

reddys310
Honored Contributor II

Re: EXCLUDE DATA

Hi Fabio,

If there is a lot of data which could possibly be excluded with the front end expression its always better to do it in your load script as this will improve your performance. Other wise Sunny's reply should help solve your issue for sure.

Thanks,

Sangram.