Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
Not applicable

How to detect loaded field and values ,data reduction on post reload

Hi,

My requirement is initially we load the data from excel. And after for data reduction we load the field and values from xcel and qlikview has to identify the loaded field and value to reduce on post reload.

Ex:-Initially loaded 10 item and to delete items 3,4 and 5.we pass these values from excel and qlikview has to identify automatically these field and values to remove after reload.

Can anyone help on these issue.

Kindly check the attachment.

Thanks,

Anil

16 Replies
Highlighted

Re: How to detect loaded field and values ,data reduction on post reload

You might be able to use Where Not Exist(Item1, Item) Where Item1 will be a field from your already loaded table

Highlighted
krishna_2644
Valued Contributor III

Re: How to detect loaded field and values ,data reduction on post reload

See attached.

Hope that helps.

Highlighted
Not applicable

Re: How to detect loaded field and values ,data reduction on post reload

customer wants to be generic and he don't known which field and values to reduce.

In the ex i just mention item 3,4 and 5.

In real case ,we have to give choice to any field or value.(Ex:Field items,Status and Store)

Highlighted

Re: How to detect loaded field and values ,data reduction on post reload

Try this script:

Table:

LOAD *,

  Item as Item1;

LOAD * Inline [

Item, Status, Store

3, 247, 25

4, 248, 24

5, 247, 25

];

Concatenate (Table)

LOAD Item,

    Status,

    Store

FROM

(ooxml, embedded labels, table is Sheet1)

Where not Exists(Item1, Item);

DROP Field Item1;

Highlighted
Not applicable

Re: How to detect loaded field and values ,data reduction on post reload

we don't known the exact field and value to reduce the data but it should be more dynamic that is applicable for any field and values.

Highlighted
krishna_2644
Valued Contributor III

Re: How to detect loaded field and values ,data reduction on post reload

See attached for custom data reduction.

Highlighted
Not applicable

Re: How to detect loaded field and values ,data reduction on post reload

ok..but input field and value should be come from external excel sheet.While loading it should detect and reduce the data not from the input box.

Highlighted
krishna_2644
Valued Contributor III

Re: How to detect loaded field and values ,data reduction on post reload

Oh, you mean user enters values which has to be reduced in an external excel sheet? or in the application itself?

Highlighted
Not applicable

Re: How to detect loaded field and values ,data reduction on post reload

yes..values to be reduce present in the excel sheet and while loading the data it has to identify and reduce those values in data model.