topic Re: How do I get a different value to the current row in a flat table in QlikView

How do I get a different value to the current row in a flat table

Thu, 09 Jul 2015 17:42:28 GMT

Hello everybody

I have a table with values, levels, descriptions, etc.

In this example i need to know in every level 3, the value of their level 1

I tried with

If( nivel = 3, Aggr(NODISTINCT Sum(Cantidad), P1N3, Estado), 0)

In the first group, the quantity is correct (201,340,001)

But in the second group is wrong (31,442,845) must be (80,333,635)

The difference is cause the last level 2 does not have a level 3 (48,890,790)

I've been trying different ways but I can't get the right result

What do you think, is this possible ??

swuehl — Thu, 09 Jul 2015 21:24:15 GMT

Try maybe like attached

Mon, 13 Jul 2015 14:56:30 GMT

That's the right solution

I have another levels and info, but using your example, i got the right results

Thanks a lot Swuehl