topic Re: selection on name in QlikView

selection on name

prma7799 — Thu, 15 Jan 2015 04:32:37 GMT

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

Re: selection on name

prma7799 — Thu, 15 Jan 2015 04:44:32 GMT

I want latest BL_DT_VPC date.

Re: selection on name

prma7799 — Thu, 15 Jan 2015 05:30:06 GMT

Hi Community,

Any idea?

Thanks

Prashant

Re: selection on name

Anonymous — Thu, 15 Jan 2015 05:51:39 GMT

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 .

Re: selection on name

kavita25 — Thu, 15 Jan 2015 06:05:30 GMT

Hi,

Post a sample application.

Regards,

Kavita

Re: selection on name

Thu, 15 Jan 2015 06:55:43 GMT

Hi prashant,

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

Re: selection on name

kamielrajaram — Thu, 15 Jan 2015 07:37:04 GMT

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

Re: selection on name

Thu, 15 Jan 2015 07:52:56 GMT

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

Re: selection on name

Thu, 15 Jan 2015 07:55:02 GMT

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.

Re: selection on name

prma7799 — Thu, 15 Jan 2015 08:32:13 GMT

Thanks Bhavana

Re: selection on name

prma7799 — Thu, 15 Jan 2015 08:41:31 GMT

Hi Kamiel,

Date

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

is ok but I want only one record for order number .....0344 but I got solution

=if(aggr(max(BL_DT_VPC),ORDER_NUM),date(aggr(max(BL_DT_VPC),SERIAL_NUM_VPC)), date(BL_DT_VPC,'DD/MM/YYYY'))

Thanks

Prashant

Re: selection on name

kamielrajaram — Thu, 15 Jan 2015 08:46:59 GMT

Hi,Glad to have helped.

Kamiel