avoiding distinct keyword on a expression

[#1]

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

[alexandros17]

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]

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

[er_mohit]

load distinct

a,

b,

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

[#5]

hi

for avoiding distinct keyword on expression,

you must define DISTINCT at script label.

ex-

load  distinct

          a,

          b

from table