One Order Agains Two Row In Pivot

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

[avinashelite]

Hi Vijay,

Can you please elaborate your requirement??? or attach the format you want so that it will be helpful for us to understand the requirement. 

[#3]

Hi Vijay

I have tried to open your test.qvw file but some issue with the attachment can you please send me your demo project and along with the attache some output result that you required.  as per my understanding 1 Order for 5 Items Right

Now second step is in your Report you have created Pivot Table that have below Dimension Fields.

Customer code

State

OrderNo

Orderdate

What is DO No and Do Date can you please elaborate this Term.

And expression filed Orderqty, orderapprove qty, doqty and you wan display one order = 1 row but in your case it shows 2 row Right? is that my understanding correct me if i am wrong

Once you send me the your Test.qvw file on my mail i can send you out put result

saumil121@redifffmail.com

Thanks

Saumil jani

[vijayit43]

Hi saumil jaini

Your understanding is correct.

DO No And DO Date is Dispatch Order No. And Dispatch Order Date

I Send Test QV Your Email Id..