topic Re: Neglecting subcategory after uploading data in QlikView

Neglecting subcategory after uploading data

aboxhammer — Tue, 15 Dec 2020 11:36:07 GMT

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

Re: Neglecting subcategory after uploading data

edwin — Tue, 15 Dec 2020 19:44:29 GMT

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
];

Re: Neglecting subcategory after uploading data

preetipriti — Mon, 11 Jan 2021 13:54:33 GMT

try this one.

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

Mcdvoice

Re: Neglecting subcategory after uploading data

Jasereze3 — Thu, 15 Sep 2022 05:25:48 GMT

Are you Looking for Matheson Gas Login then check here Matheson Gas Login Official portal.

Re: Neglecting subcategory after uploading data

Blackjonh — Fri, 27 Jan 2023 04:24:30 GMT

Very good, I think I found the knowledge I needed. I will see and refer to some information in your post. thank you!

Click Here

Re: Neglecting subcategory after uploading data

mewab50087 — Thu, 27 Jul 2023 03:48:15 GMT

MyHealth Plan Account, which can significantly help individuals take control of their health-related expenses and make informed financial decisions.
https://www.diigo.com/item/note/ahpg9/yi3j?k=7ce125c3a5cb64a4ca25030380ba2da2

Re: Neglecting subcategory after uploading data

Nderfdrdsrcs — Thu, 14 Sep 2023 09:10:42 GMT

In this article, we will delve into the various aspects of how MyMercy Login is transforming patient-centric care. From personalized treatment plans to seamless access to medical information, MyMercy is setting new standards for the healthcare industry. https://gaatz-ploialls-hyauently.yolasite.com/