topic Set Analisys Modifier in QlikView

Set Analisys Modifier

Tue, 05 Jan 2010 16:18:22 GMT

Hi all

with Rel 8.5 this expression was marked as OK

Count(distinct {$<DOCLIE={'000000'}>} DOKSCL) and works well

-------

while with Rel 9.0

is marked as "Error in Expression" when I try to change it and

the column show an empty value

Someone know why ???

Many Thanks

Claudio

Tue, 05 Jan 2010 16:40:50 GMT

Hi Claudio, try with tis:

Count

({$ <DOCLIE={'000000'}> }DISTINCT DOKSCL )

Regards

Tue, 05 Jan 2010 17:49:20 GMT

Hi ,

many thanks for your answer.

Now it works wll with the '=" sign.

If i have to compare where the field DOCLIE is greater than (using always >) it doesn't work

count ({$ <DOCLIE>{'000000'}> }DISTINCT DOKSCL )

Thanks again

Tue, 05 Jan 2010 19:30:29 GMT

Try:

count ({$ <DOCLIE = {'>000000'}> }DISTINCT DOKSCL )

Wed, 06 Jan 2010 15:14:37 GMT

Hello!

I'm sorry for my English but I'm French and not verry good in English!

I want to know how do <> in set analysis. For example, Count({$<DOCLIE<> {'000000'}>}distinct DOKSCL) .

I want do a different, but I don't arrive to do.

Anyone can help me? Thank you very much for your help!

Wed, 06 Jan 2010 15:21:46 GMT

I believe that would be:

Count({$<DOCLIE -= {'000000'}>}distinct DOKSCL)

The -= symbol is the exclusion. Meaning you would get everything except DOCLIE = '000000'.

Wed, 06 Jan 2010 15:31:13 GMT

Thank you very much! You are my Hero!! Good Day!