topic Re: Disconnect Category on maximum lastmodifieddate in QlikView

Disconnect Category on maximum lastmodifieddate

SunilChauhan — Tue, 30 Aug 2011 13:02:12 GMT

i want to show disconnect category only on maximum lastmodifiedDate

see the attched file

fast reply watewill be appriciated

lironbaram — Tue, 30 Aug 2011 13:42:59 GMT

hei

attach is an example hope its helps you

SunilChauhan — Tue, 30 Aug 2011 13:51:49 GMT

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 — Tue, 30 Aug 2011 14:01:48 GMT

hei

ok try this

i did the check in the load script

take a look

SunilChauhan — Tue, 30 Aug 2011 14:23:45 GMT

order by SAP_Customer_No__c , LastModifiedDate DESC

this iss not working in qlikview 9.0
is there any option

lironbaram — Tue, 30 Aug 2011 14:27:29 GMT

hei

i just reload it in ver 9 and it worked

what is the error messge you get