Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Exclusiones

Estimados,

     Requiero apoyo para poder hacer exclusiones en un aplicativo, tengo cargados dos archivos, el archivo 1 tiene el inventario de la compañía y el archivo 2 tiene la exclusiones, requiero que el aplicativo NO muestre la información que encuentre en el archivo 2, de qué modo lo puedo realizar? Soy prácticamente un neófito en el tema.

Dears,

     I need your help to make exclusions on an app, I have two file loaded, the 1st has the company's inventory and the 2nd has the exclusions, I need the app doesn't show the information found on the 2nd file, how can I do that? I'm new in this.

Agradezco el apoyo

Thanks the support

Saludos

Regards

Carlos

4 Replies

Re: Exclusiones

You can use the Exists function in a where clause. See this document for more information: Where not Exists and Exits


talk is cheap, supply exceeds demand
reddys310
Honored Contributor II

Re: Exclusiones

Hi Carlos,

As Gysbert as suggested you can exclude data in the script using the Where not Exists and Exits and this is what you need. You can even perform calculations on only the data you would like from the front end side using set analysis expressions.

Not applicable

Re: Exclusiones

Thanks Gysbert! I've used the function and it works amazing! Thank you so much!

Not applicable

Re: Exclusiones

Yes Sangram, I used it and it works!

Community Browser