Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
fmazzarelli
Partner - Creator III
Partner - Creator 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
sunny_talwar

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*'}>}

Kushal_Chawda

Create a flag in script

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


Now in Expression use this flag


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

jonathandienst
Partner - Champion III
Partner - Champion III

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)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
reddy-s
Master II
Master II

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.