topic Nested IF Statement in Pivot Table in QlikView

Nested IF Statement in Pivot Table

Tue, 22 Mar 2011 17:10:08 GMT

Can I use Nested IF statements in pivots table to show different data depending on what value a particular field show.

I have a standard if statement working, but have three possible values hence the requirement for nested which I can't seem to get to work.

Working IF Statement

if(component_make_or_buy='M',rangesum(wo_quantity_remaining),rangesum(sum(po_qty_ordered)-sum(po_qty_received)))

Non working Nested IF Statement

if(component_make_or_buy='M',rangesum(wo_quantity_remaining),if(component_make_or_buy='B',rangesum(sum(po_qty_ordered)-sum(po_qty_received)))

I know there are only two elements above but I planned to add the third once this was working.

Nested IF Statement in Pivot Table

Anonymous — Tue, 22 Mar 2011 18:16:50 GMT

Your second expression with the nested IF() is missing a closing parenthesis. You will also want to be careful to insure that the field you are testing (component_make_or_buy) can only have a single value at any time or the expression will return null.

Nested IF Statement in Pivot Table

Anonymous — Tue, 22 Mar 2011 18:59:23 GMT

Hi.

Technically, there is no problem to use nested if's in Pivotable, we've done it.

However, it will be a lot more performant to do those calculations in your loading script (btw, it will be more readeable to the user too, when creating new objects).

Best regards,

Miguel Catalao

Nested IF Statement in Pivot Table

Wed, 23 Mar 2011 09:05:20 GMT

Thanks, it was just that missing bracket.