topic Re: apply distinct in qv data model in QlikView

apply distinct in qv data model

gizzel123 — Wed, 21 Jan 2015 17:50:32 GMT

I have a query-select distinct col1,col2... From table 1 ,table 2 where....

so I have implemented the whole logoc except the distinct.

if I ll check my model by not including distinct.its fine.

but the business requirement is to have distinct.

can u guys please help.

I really stucked.

thanks in advance

Re: apply distinct in qv data model

Anonymous — Wed, 21 Jan 2015 17:53:54 GMT

Not clear what exactly is wrong if you use distinct. Need some more info...

Re: apply distinct in qv data model

NickHoff — Wed, 21 Jan 2015 18:08:48 GMT

Qlikview will automatically group your data based on how you build your data model. So the DISTINCT logic is being built in without actually using DISTINCT. However, everything depends on how your data model is setup DISTINCT can be useful to help limit your data set in certain cases.

Re: apply distinct in qv data model

gizzel123 — Wed, 21 Jan 2015 18:17:36 GMT

so where do I apply the distinct in script,

I am a novice in qlikview modelling.

is it in load distinct * resident table_name; ???

but this way I get zero records.

Re: apply distinct in qv data model

NickHoff — Wed, 21 Jan 2015 18:20:49 GMT

You missed the point. If Qlikview automatically groups your data based on how your data model is built, it's already applying distinct.

However, if you are attempting to limit your data set in the load. Then distinct is a predicate used if only the first of duplicate records should be loaded Typically

You'll have

LOAD COUNT(DISTINCT Field1) AS Field1Count ,

Field1,

Field2,

Re: apply distinct in qv data model

rwunderlich — Wed, 21 Jan 2015 19:32:38 GMT

You can also apply DISTINCT as a keyword right after LOAD

LOAD DISTINCT

field1,

field2

...

-Rob