Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You might be able to use Where Not Exist(Item1, Item) Where Item1 will be a field from your already loaded table
See attached.
Hope that helps.
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)
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;
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.
See attached for custom data reduction.
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.
Oh, you mean user enters values which has to be reduced in an external excel sheet? or in the application itself?
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.