topic Re: Set analysis Expression for a single item in QlikView

Set analysis Expression for a single item

Anonymous — Fri, 16 May 2014 03:27:44 GMT

In a pivot table having item codes, and sum of item cost (with some calculations and conditions), I want to have separate calculation for just one item. How do I do that in the fronted using set analysis?

Eg.

Header 1	Header 2
10001	4567
10002	232131
10003	32233
10004
10005	3486

Here I want 10004 to be calculated as 10002/10001 (Division) i.e. (232131/4567). How do I do?

TIA

Re: Set analysis Expression for a single item

robert_mika — Fri, 16 May 2014 04:14:43 GMT

What's the logic behind that?

What if you had two gaps?

Re: Set analysis Expression for a single item

MayilVahanan — Fri, 16 May 2014 04:58:04 GMT

Try using if condition something like this

=If([Header 1] = 10004, Above([Header 2],2)/Above([Header 2],3), Sum([Header 2]))

Re: Set analysis Expression for a single item

Anonymous — Fri, 16 May 2014 09:25:07 GMT

Which two gaps?

Re: Set analysis Expression for a single item

Anonymous — Fri, 16 May 2014 10:28:02 GMT

Thank you Mayil. But this is just an example. the real data has dynamic labels, alternate states and many rows. so unable to implement it.

Re: Set analysis Expression for a single item

Anonymous — Fri, 16 May 2014 10:32:30 GMT

It is a P&L report where a particular code is a division result of two codes.

Re: Set analysis Expression for a single item

robert_mika — Sat, 17 May 2014 07:20:05 GMT

You gave example with one gap.

What if you have more than one gap or gaps with two or more rows

Re: Set analysis Expression for a single item

SunilChauhan — Sat, 17 May 2014 07:38:31 GMT

simply use below funtion

below(Header2)/Header2

below(sum(Header2))/sum(Header2)

hope this helps

Re: Set analysis Expression for a single item

tresB — Sat, 17 May 2014 07:47:21 GMT

Have a look here: New value as quotient of other two value