topic Is it possible to write count(distinct Tickets ID) in model level in QlikView

Is it possible to write count(distinct Tickets ID) in model level

Wed, 23 Sep 2015 12:46:34 GMT

Is it possible to write count(distinct Tickets ID) in data model level??

marcus_sommer — Wed, 23 Sep 2015 12:49:56 GMT

Surely, but the whole load-statement needs to be adjusted to such a calculation. It should look like:

count:

Load AnyGroup, count(distinct [Tickets ID]) as TicketCount From xyz Group by AnyGroup;

- Marcus

tresB — Wed, 23 Sep 2015 12:49:57 GMT

Possible. Try like:

Load

Field1,

Field2,

Count( Distinct Field3) as Count

From <> Group By Field1, Field2;

sunny_talwar — Wed, 23 Sep 2015 13:07:36 GMT

Not sure what you mean when you say Data Model level? Do you mean to do this in the script?

Wed, 30 Sep 2015 04:58:21 GMT

Yes it is script level