topic Re: Qlik View Aggr Sum In One Row in QlikView

Qlik View Aggr Sum In One Row

vijayit43 — Mon, 25 Aug 2014 06:16:14 GMT

In My QlikView DashBoard for Example One Order and One Order Agains 5 Item Then we Create DO only 4 Item 1 Item Left ,Now My Report we create a Pivot as Dimension Field customer code,state,orderno, orderdate,DO No and DO Date and expression field Orderqty,orderapprove qty,doqty,,, we want to show that one order agains one row come but it show 2 rows. how to Manage It Please Help and sorry for bad english.for refrense Test QV Attached...

Re: Qlik View Aggr Sum In One Row

PrashantSangle — Mon, 25 Aug 2014 06:30:01 GMT

Hi,

Try this

Go to

Property->dimension tab->select SALEID->Supress when value is Null(tick)->apply

Regards,

Re: Qlik View Aggr Sum In One Row

vijayit43 — Mon, 25 Aug 2014 06:44:50 GMT

That Time Actual Quantity&ASM quantity Also Remove But We want to both Quantity in SalesID line sum