topic Re: filtering in QlikView

filtering

janardhan — Tue, 06 Nov 2012 11:21:17 GMT

Hi friends ,

please find the attachement , here is the Objectid is repeated so i need to eliminate the repeated one , my requirement is

ObjectID WSTYPE QTY

OTG115120A001 Normaltid 27

I need like this

Re: filtering

Tue, 06 Nov 2012 11:38:47 GMT

Hai,

Use distinct of ObjectID ,Sorry if i didnt understand you correctly.

Thanks

Re: filtering

jagan — Tue, 06 Nov 2012 11:41:22 GMT

Hi Janardhan,

Can you attach the sample file with data?

Regards,

Jagan.

Re: filtering

Tue, 06 Nov 2012 11:42:19 GMT

Hai,

Plese use the distinct function for id

distinct(object id)

Re: filtering

MayilVahanan — Tue, 06 Nov 2012 18:42:27 GMT

Are you looking like this

Load * Inline

[

ObjectID,WSTYPE,QTY

OTG115120A001,Normaltid,27

OTG115120A001,Normaltid,

] where Len(Trim(QTY)) > 0;

in script??

its load where qty has value only

Re: filtering

vgutkovsky — Tue, 06 Nov 2012 22:20:53 GMT

Well, the simple answer is that you're using a Table Box when you probably want a Straight Table. Create a Straight Table with dimensions ObjectID and WSTYPE and expression sum(QTY)

Regards,

Vlad