Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analisys Modifier

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





1 Solution

Accepted Solutions
Not applicable
Author

Hi Claudio, try with tis:

Count

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

Regards

View solution in original post

6 Replies
Not applicable
Author

Hi Claudio, try with tis:

Count

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

Regards

View solution in original post

Not applicable
Author

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

Not applicable
Author

Try:

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


Not applicable
Author

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!

Not applicable
Author

I believe that would be:

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


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

Not applicable
Author

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