Disconnect Category on maximum lastmodifieddate

[SunilChauhan]

i want to show disconnect category only on maximum lastmodifiedDate

see the attched file

fast reply watewill be appriciated

[lironbaram]

hei

attach is an example hope its helps you

[SunilChauhan]

thanks for ur reply but i want only one value of disconnect reason in chart CH01

if u will see then there are some Sap Customer who have two disconnect reason

but i want only one on max modified date

[lironbaram]

hei

ok try this

i did the check in the load script

take  a look

[SunilChauhan]

order by SAP_Customer_No__c , LastModifiedDate DESC

this iss not working in qlikview 9.0

is there any option

[lironbaram]

hei

i just reload it in ver 9 and it worked

what is the error messge you get