topic Re: Load Data: Only Load columns that have an specific value under other column in Visualization and Usability

Load Data: Only Load columns that have an specific value under other column

patriciousa — Tue, 30 Aug 2016 17:42:03 GMT

Hi Community, hope someone can help me out with this.

I have an excel with the following info:

Company	Code	Item	Owner	Price	Currency	AmountQ
5000	199999	Bananas	Patrick	401	EUR	290000
5000	200493	Oranges	Mathew	394	EUR	29500
5100	224004	Apples	Louis	330	USD	300000
5400	303404	Ice Cream	Christian	502	USD	503000

Before loading the data to Qlik, I want to Load ALL coumns but only when the CODE column is between 200000 and 299999.

Once uploaded to Qlik, this should be the only visible data:

Company	Code	Item	Owner	Price	Currency	AmountQ
5000	200493	Oranges	Mathew	394	EUR	29500
5100	224004	Apples	Louis	330	USD	300000

Thank you in advance.

Regards.

sunny_talwar — Tue, 30 Aug 2016 17:53:53 GMT

May be this:

Table:

LOAD Company,

Code,

Item,

Owner,

Price,

Currency,

AmountQ

FROM

[https://community.qlik.com/thread/230929]

(html, codepage is 1252, embedded labels, table is @1)

Where Code >= 200000 and Code <= 299999;

patriciousa — Tue, 30 Aug 2016 18:06:06 GMT

Thank you Sunny.