Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

josecanalla
New Contributor III

Get value of pivot table

Hello, I have this model loaded (note that ADM_PLAN_CUENTA-Expandednodes1 is a hierarchy table)

Screenshot_4.png

With this I create a pivot table which works correctly:

Screenshot_3.png

Now, I want to know by code the value, for example, of "RECURSOS CORRIENTES" to do a calculation with this. It is the sum of the nodes below this. I need exact the same value I can see in the pivot table, month by month.

How can I get it?

Thanks!

2 Replies
kidbank3
Contributor III

Re: Get value of pivot table

Jose,

I recommend looking into the aggr function.  I can't be more specific with the given information.

What code are you talking about?

Mike

josecanalla
New Contributor III

Re: Get value of pivot table

Mike, thanks for your reply. I don't see how the Aggr function help me.

I am talking about code for example in a KPI chart. I want to take the value of the pivot table.

Thanks!

Community Browser