Discussion Board for collaboration related to QlikView Deployment.
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?
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
for avoiding distinct keyword on expression,
you must define DISTINCT at script label.