Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can i do a count distinct in the script itself instead of doing it in expression
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;
What about the code? Has it been helpful for you?
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
hi
for avoiding distinct keyword on expression,
you must define DISTINCT at script label.
ex-
load distinct
a,
b
from table