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: 
german_avanzato
Creator
Creator

Set Analysis base on table content

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.

1 Solution

Accepted Solutions
Not applicable

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])

JG

View solution in original post

2 Replies
Not applicable

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])

JG

german_avanzato
Creator
Creator
Author

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