topic Re: Data Reduction by the opossite in QlikView

Data Reduction by the opossite

fkeuroglian — Tue, 22 Dec 2015 14:21:28 GMT

Hi Experts!

I want to know if it possible to use data reduction in section acces by the oppossite, for example:

USER REGION

1 10,20,30,40

2 50

If i want to create an excel to reduce data, the only way is create a registry for every region to the user 1?

for example:

USER REGION

1 10

1 20

1 30

1 40

2 50

there is another way? for example, in 1 line something like <> 50?

thank you a lot

Fernando K.

Re: Data Reduction by the opossite

maxgro — Tue, 22 Dec 2015 23:06:06 GMT

if you want to use some rule in excel, you have to add the logic in the load script to change the rule to the usual format of the section access (list of accepted values or *)

example you want to exclude values

-50

the pseudo code would be

if there is a -xvalue for a field and user

the section access for the user will be all values of the fields excluding -xvalues

I think it can become quite complicated

Re: Data Reduction by the opossite

marcus_sommer — Wed, 23 Dec 2015 08:59:43 GMT

I think your end-result for the section access needs to look like this one:

USER REGION

1 10

1 20

1 30

1 40

2 50

But you didn't need to start there. If you load such table:

USER REGION

1 10,20,30,40

2 50

with a subfield(REGION, ',') you could create the needed data-structure.

- Marcus