selection on name

[prma7799]

Hi All,

I have one question that I want only one name when I select serial number .....9221 then it will show me only B.U bhandari name and order number .....0344

PFA

Thanks

Prashant

[prma7799]

I want latest BL_DT_VPC date.

[prma7799]

Hi Community,

Any idea?

Thanks

Prashant

[Anonymous]

So in chart you just want to show latest record for Serial no. and name order ...

Am I correct ?

can you share a sample qvw .

[kavita25]

Hi,

Post a sample application.

Regards,

Kavita

[#6]

Hi prashant,

find sample file in attachment,hope this helps you in your scenario

[kamielrajaram]

Hi Prashantbi,

Hope this helps

Name -

=Aggr(FirstSortedValue(NAME, -BL_DT_VPC),SERIAL_NUM_VPC)

Order Num

=Aggr(FirstSortedValue(ORDER_NUM, -BL_DT_VPC),SERIAL_NUM_VPC)

Date

=Aggr(FirstSortedValue(Date(Floor(Date(BL_DT_VPC)),'DD/MM/YYYY'), -BL_DT_VPC),SERIAL_NUM_VPC)

Regards

Kamiel

[#8]

We can write macro for this. It Wil show the data which is selected only.

[#9]

sub a

set LB = ActiveDocument.GetSheetObject("LB29")

set box=LB.GetProperties

box.Layout.HideExcluded = true

LB.SetProperties box

end sub

here LB29 is the object ID for that list box.

[prma7799]

Thanks Bhavana