Qlik View Aggr Sum In One Row

[vijayit43]

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...

[PrashantSangle]

Hi,

Try this

Go to

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

Regards,

[vijayit43]

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