topic Re: Dimension need to neglet in QlikView

Dimension need to neglet

ajithsachin — Fri, 13 Feb 2015 14:00:03 GMT

Hi All,

My table contains data like this.

and need result like this

actually i need to neglect the dimension to bring the ware house stock.

Regards,

Ajith

alexandros17 — Fri, 13 Feb 2015 16:00:02 GMT

Use this expression for the Warehouse stock column:

Agg(NODISTINCT Sum({$ <Branch={'WareHouse'}>} Stock), Item)

and in the dimension write:

If(Branch <> 'WareHouse', Branch, Null())

and check the "Suppress Null Value" box

let me know

ajithsachin — Fri, 13 Feb 2015 17:59:59 GMT

Thank u very much..