topic Re: avoiding distinct keyword on a expression in QlikView

avoiding distinct keyword on a expression

Mon, 26 Jan 2026 18:19:17 GMT

How can i do a count distinct in the script itself instead of doing it in expression

alexandros17 — Wed, 30 Jan 2013 14:04:40 GMT

it depends on SQL Syntax if you have a DB

select count(distinct Field) from Table

if you want to do the same thing in a Qlik View Table:

LOAD count(distinct Field) as Alias resident Table;

alexandros17 — Thu, 31 Jan 2013 09:28:27 GMT

What about the code? Has it been helpful for you?

er_mohit — Thu, 31 Jan 2013 09:34:38 GMT

load distinct

c from table;

here if there is duplicate records in this table then using distinct they ll be unique then use expression

count(a). it gives distinct records...

you can use count function in script also

Thu, 31 Jan 2013 09:39:13 GMT

for avoiding distinct keyword on expression,

you must define DISTINCT at script label.

ex-

load distinct

from table