Distinct option has been disable

[#1]

Good day,

the distinct in Edit Expression has been disable, is there a way to enable the distinct button in the expression ??

[alexandros17]

Give more detail please

[awhitfield]

Hi Lester,

does this refer to Qlikview OR Qlik Sense?

Andy

[oknotsen]

Please show up the current expression and, as Alessandro already wrote, supply us with (a lot) more details please. Describe what you did, what you need to achieve, what object(s ) are involved, etc.

[#5 · Accepted solution]

HI Lester

The distinct option in the Edit Expression dialogue box is normally disabled until you select an aggregation function at which point it becomes enabled.

See below the Distinct option is disabled as there is no Aggregation function selected.

However, once an aggregation function is selected it will become enabled so you can tick it if you want.

Hope that helps.

Kind regards

Steve