Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
Not applicable

Data reduction

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 ?

1 Solution

Accepted Solutions
MVP
MVP

Re: Data reduction

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)

4 Replies

Re: Data reduction

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.


talk is cheap, supply exceeds demand
MVP
MVP

Re: Data reduction

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)

Not applicable

Re: Data reduction

Thks for reply;

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

Not applicable

Re: Data reduction

Great, thanks a lot!

Community Browser