topic Set analysis not equal in QlikView

Set analysis not equal

Thu, 27 Nov 2014 12:25:57 GMT

Hi all,

this is my formula

=Count( {$<[State]={'Closed'},[Work Item Type]={'Task'}>} [State] )

i want to get all 'Task' not equal to 'Closed' .how to do this in qv

I tried below code but its not working

=Count( {$<State=- {'Closed'},[Work Item Type]={'Task'}>} [State] )

PrashantSangle — Thu, 27 Nov 2014 12:29:17 GMT

=Count( {$<State-= {'Closed'},[Work Item Type]={'Task'}>} [State] )

Regards

Thu, 27 Nov 2014 12:33:15 GMT

its getting a error

PrashantSangle — Thu, 27 Nov 2014 12:36:29 GMT

Hi,

It shows your red line but it work fine.

check it.

Regards

Thu, 27 Nov 2014 12:38:38 GMT

using -= like that in set analysis does highlight as an error but it is actually correct and should calculate for you

ashwanin — Thu, 27 Nov 2014 12:58:50 GMT

=Count( {$<State-={'Closed'},[Work Item Type]={'Task'}>} [State] )

Joe is right. this expression will work, even it will reflect the red line.

rajeshvaswani77 — Thu, 27 Nov 2014 13:01:03 GMT

Hi,

This will still work in spite of the red line.

thanks,

Rajesh Vaswani