topic Re: Data reduction in QlikView

Data reduction

Thu, 05 Nov 2015 09:44:16 GMT

Hello Guys,

Is there a way to reduce data by section access and to show all data on another field:

ex:

Section Access;

Star is *;

LOAD * INLINE

[

ACCESS,USERID,PASSWORD,AGENCE,YEAR

ADMIN,AGBRT,toto,AGBRT,*

USER,IDF,titi,IDF,*

];

Section Application;

Produit:

load * inline

[

AGENCE,Produit,YEAR

AGBRT,XXX,2014

AGBRT,XXS,2015

AGBRT,XXL,2013

AGBRT,XZX,2011

IDF,UUP,2014

IDF,UUZP,2014

IDF,UUSP,2012

IDF,UUFP,2010

];

Calendrier:

load * inline

[

YEAR

2010

2011

2012

2013

2014

2015

];

In this example i want to reduce data on AGENCE field but i want to show all YEAR even if i don't have data ?

Re: Data reduction

Gysbert_Wassenaar — Fri, 06 Nov 2015 14:31:34 GMT

That should be possible.

Your section access table won't work though. The star will allow access to all listed values. In your table no values are listed. So the * will allow access to nothing. Simply leave YEAR out completely and you'll get all values available.

Re: Data reduction

swuehl — Fri, 06 Nov 2015 14:38:25 GMT

Maybe remove the YEAR from the section access table and add this at the end of the section application:

TMP:

LOAD YEAR

RESIDENT Calendrier;

JOIN (TMP)

LOAD AGENCE, AGENCE AS CHECK RESIDENT Produit

WHERE NOT EXISTS(CHECK, AGENCE);

DROP FIELD CHECK;

CONCATENATE (Produit)

LOAD AGENCE, YEAR RESIDENT TMP;

DROP TABLE TMP;

edit:

CONCATENATE (Produit)

Re: Data reduction

Fri, 06 Nov 2015 15:46:48 GMT

Thks for reply;

It's was the first thing i did but it doesn't work anymore

Re: Data reduction

Fri, 06 Nov 2015 15:57:31 GMT

Great, thanks a lot!