topic Set Analysis base on table content in QlikView

Set Analysis base on table content

german_avanzato — Tue, 05 Feb 2013 14:28:21 GMT

Hi,

I looked everywhere and I can't find the way to achieve this.

I have a table simple with the next expression:

Sum ({<[A período_PERBI.COBK] ={001} ,Ejercicio_GJAHR.COEP ={$(vEjerMant)} ,[Clase de coste] ={'0623010000','0630030000','0630030100','0630030200','0630030400','0630030500','0630030600','0630040000','0630040200','0630110000','0630110100'} >}[Valor/Moneda objeto_WOGBTR.COEP])

What i want to achieve is that the [Clase de Coste] is filtered with the content of a table, so the filter is not hard coded in the "Analysis Set"

Something like this :

MantenimientoCuentas:

LOAD * Inline [CuentaMant,

0623010000,

0630030000,

0630030100,

0630030200,

0630030400,

0630030500,

0630030600,

0630040000,

0630040200,

0630110000,

0630110100,

];

And then use something like:

Sum ({<[A período_PERBI.COBK] ={001} ,Ejercicio_GJAHR.COEP ={$(vEjerMant)} ,[Clase de coste] = CuentaMant >}[Valor/Moneda objeto_WOGBTR.COEP])

If there is any different approach with the same result, it's the same for me.

Thanks.

Re: Set Analysis base on table content

Tue, 05 Feb 2013 14:50:23 GMT

Hi xx,

Have you tried with the P() modifier in the set analysis? It should be something like this:

Sum ({<[A período_PERBI.COBK] ={001} ,Ejercicio_GJAHR.COEP ={$(vEjerMant)} ,[Clase de coste] = P({1} CuentaMant) >}[Valor/Moneda objeto_WOGBTR.COEP])

Re: Set Analysis base on table content

german_avanzato — Tue, 05 Feb 2013 15:03:04 GMT

I swear I readed this file http://community.qlik.com/servlet/JiveServlet/download/294471-52028/QlikLearn-Set-Analysis.pdf and I don't understand how to use the P({}) statement.

It worked perfectly, you won the points