# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for
Did you mean:
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:

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

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

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

Community Browser