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

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

Thu, 13 Aug 2015 15:53:10 GMT

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

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

sunny_talwar — Thu, 13 Aug 2015 15:59:40 GMT

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

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

Qrishna — Thu, 13 Aug 2015 16:04:07 GMT

See attached.

Hope that helps.

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

Thu, 13 Aug 2015 16:07:44 GMT

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)

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

sunny_talwar — Thu, 13 Aug 2015 16:11:24 GMT

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;

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

Thu, 13 Aug 2015 16:12:34 GMT

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.

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

Qrishna — Thu, 13 Aug 2015 16:19:42 GMT

See attached for custom data reduction.

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

Thu, 13 Aug 2015 16:27:48 GMT

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.

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

Qrishna — Thu, 13 Aug 2015 16:29:09 GMT

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

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

Thu, 13 Aug 2015 16:32:03 GMT

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.

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

Qrishna — Thu, 13 Aug 2015 16:40:17 GMT

See attached files.

Input values in the excel sheet called 'Data To be reduced' and save the excel.

reload the application.

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

Thu, 13 Aug 2015 17:25:23 GMT

ok it works...but we want to do reduce data on post reload...

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

Qrishna — Thu, 13 Aug 2015 17:26:55 GMT

ya thats the post reload only.

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

Qrishna — Thu, 13 Aug 2015 17:29:43 GMT

Oh do you mean, you reload the application, then enter the reduction values in the excel sheet?

Then its not possible with an external file.

if you are making any changes in the external file and the changes be implemented in the app then you have to reload the application.

i have provided you 3 solutions, you can choose one.

According to your requirement the last one is much suitable.

thanks

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

Thu, 13 Aug 2015 17:34:29 GMT

we don't want to change the script..but reduce data on post reload.

like using Onpostreload trigger.

Using macro

ActiveDocument.ReduceData function.

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

Thu, 13 Aug 2015 17:37:41 GMT

I am able to reduce the data when we manually selected the field value from the application and able to reduce the data after reload.

But i am facing the problem with how to pass the values dynamically values from Excel and reduce data.

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

Qrishna — Thu, 13 Aug 2015 17:39:04 GMT

you are not changing any script here.

you just input the values/fields to be reduced in the external excel(as you requested) then reload the application.

the data automatically gets reduced.