topic Re: Set Analysis - no equal to does not work in QlikView

Set Analysis - no equal to does not work

Fri, 15 May 2015 19:42:16 GMT

Hi,

Please let me know what is wrong with the below syntax:

=count (
{<
[FLAG] = {'I'}, [STATUS] <> {'CIO Review'}
>}
Distinct RAV_CASE_ID
)

Thanks,

Sudha.

Re: Set Analysis - no equal to does not work

Agis-Kalogiannis — Mon, 18 May 2015 08:10:10 GMT

You cannot use <> in set analysis.

You can do something like

[STATUS] =- {'CIO Review'}

Can you try and let me know?

Thanks

Agis

Re: Set Analysis - no equal to does not work

Mon, 18 May 2015 13:34:56 GMT

Hi Agis,

Thanks for your help!

Still I am getting some error; not sure what I am missing -

=count (
{<
[FLAG] = {'I'}, [STATUS] =- {'CIO Review'}>}
Distinct RAV_CASE_ID
)

Re: Set Analysis - no equal to does not work

Gysbert_Wassenaar — Mon, 18 May 2015 13:46:34 GMT

The syntax checker of the expression editor has a bug that causes it to incorrectly flag the -= construction as a syntax error. It isn't, the syntax checker is in error.

Re: Set Analysis - no equal to does not work

Mon, 18 May 2015 13:59:39 GMT

Oh Ya! That's right. It's working fine now. Thank you

Re: Set Analysis - no equal to does not work

Agis-Kalogiannis — Thu, 02 Jul 2015 20:07:20 GMT

Can you please mark one of the answers as helpful or correct so as to close the discussion?

I would appreciate it.

Thanks

Agis