Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
swuehl
MVP
MVP

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)

View solution in original post

4 Replies
Gysbert_Wassenaar

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
swuehl
MVP
MVP

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
Author

Thks for reply;

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

Not applicable
Author

Great, thanks a lot!