topic Re: Set Analysis in QlikView

Set Analysis

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

HI All please find the below set analysis code and please let me know if it is correct

1. count(DISTINCT {$<Name={'Rexona',}>}%Product) = Should give me the distinct count of Product only for rexona ,

2.count(DISTINCT {$<DRGRSLT={'Rexona','Lux'}>}%IncidentKey) = should give me the disticnt count of Rexona plus Lux

avinashelite — Mon, 07 Mar 2016 10:08:12 GMT

yes its correct ...

//one extra comma(,) not required

count(DISTINCT {$<Name={'Rexona'}>}%Product) = Should give me the distinct count of Product only for rexona ,

alexandros17 — Mon, 07 Mar 2016 10:08:45 GMT

Comma must be deleted ...

from

count(DISTINCT {$<Name={'Rexona',}>}%Product)

count(DISTINCT {$<Name={'Rexona'}>}%Product)

kaushiknsolanki — Mon, 07 Mar 2016 10:09:16 GMT

count(DISTINCT {$<Name={'Rexona',}>}%Product)

You have extra , here.... remove it..

Correct.

count(DISTINCT {$<Name={'Rexona'}>}%Product)

Second one is right.

Regards,

Kaushik Solanki

sunny_talwar — Mon, 07 Mar 2016 10:09:19 GMT

1st looks right, but just remove the comma after 'Rexona'

Count(DISTINCT {$<Name={'Rexona'}>} [%Product])

2nd one is using DRGRSLT and 1st expression using Name. Should both of them be using the same field name?

Count(DISTINCT {$<DRGRSLT={'Rexona', 'Lux'}>} [%IncidentKey])

Digvijay_Singh — Mon, 07 Mar 2016 10:14:33 GMT

This below -

{'Rexona','Lux'}

is interpreted as Rexona OR Lux so both will be considered.