Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
aboxhammer
Contributor
Contributor

Neglecting subcategory after uploading data

Hi there,

I need to provide a table with schedulers and their products, but my excel data base contains schedulers from other units I need to exclude without changing the excel file.

When using if or wildmatch in the table collums my whole column shows no values.

Is there an easy way to

1) make qlik neglect those schedulers I dont need after loading the data, like an if or filter function in the data preparation?

Thanks a lot and stay healthy

Andi

3 Replies
edwin
Specialist III
Specialist III

match should work esp if you know which ones specifically to include or exclude.  try this (it will retain anything not in the list):

load *
where match(Cust,'BC','NNN','NDS')=0;
load * inline [
Cust
A
BC
NDS
DEF
];

 

Pullman
Contributor
Contributor

If Wallet imported your data but did not auto-categorized, please note that categorization is a Premium feature. ... that you set the right value for the Note field when you set Import rules.  I have meticulously used the exact same category and subcategory  Budgetbakers app ignores these names  totally

preetipriti
Contributor
Contributor

try this one.

load *
where match(Cust,'BC','NNN','NDS')=0;
load * inline [
Cust
A
BC
NDS
DEF
]; 

Mcdvoice