Re: Set analysis not equal - Qlik Community

Report Inappropriate Content · ‎2014-11-27

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 · ‎2014-11-27

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Report Inappropriate Content · ‎2014-11-27

its getting a error

PrashantSangle · ‎2014-11-27

Hi,

It shows your red line but it work fine.

check it.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Report Inappropriate Content · ‎2014-11-27

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

ashwanin · ‎2014-11-27

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

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

rajeshvaswani77 · ‎2014-11-27

Hi,

This will still work in spite of the red line.

thanks,

Rajesh Vaswani