Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

avoiding distinct keyword on a expression

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

4 Replies

Re: avoiding distinct keyword on a 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;

Re: avoiding distinct keyword on a expression

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

er_mohit
Honored Contributor II

Re: avoiding distinct keyword on a expression

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

Not applicable

Re: avoiding distinct keyword on a expression

hi

for avoiding distinct keyword on expression,

you must define DISTINCT at script label.

ex-

load  distinct

          a,

          b

from table

Community Browser