Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

SET ANALYSIS

Count( {$<Priority={'High'}, Status - ={'Closed'}>} Distinct %CaseId )

What does ' - ' sign (after status) indicate?  Could anyone please help me out with this?

Thanks

10 Replies
tresesco
MVP
MVP

'-' sign indicates negation here. I.e. all status which are NOT 'Closed'.

sasiparupudi1
Master III
Master III

count distinct %CaseId where  Status in not 'Closed' and having 'High' Priority

hth

Sasi

jonathandienst
Partner - Champion III
Partner - Champion III

Check these two sections in the manual:

Set Operators (p824)

Set Modifiers Using Assignments with Implicit Set Operators (p827)

(Page numbers from 11.20 SR9 Manual)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
jagan
Luminary Alumni
Luminary Alumni

Hi,

It will exclude the Closed Status from Counting.

-= -- Negates (ignores) the given values

Regards,

Jagan.

brunobertels
Master
Master

Hi ,

This mean :

Count distinc "% case ID"

Where "Priority" is "Hight"

But only if "Status" is différent from "Closed". the sign "-" before = exclude values

This tool may help you also to build or to understand your set analysis :

http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx

it is written by Stefan Walther

Regards,

Bruno

Anonymous
Not applicable
Author

It'll ignore 'closed' and gives the result.

Can be written as

Count( {$<Priority={'High'}, Status  = {'*'}{'Closed'}>} Distinct %CaseId )

{'*'}  gives all the possible values in Status

Thanks

ganeshreddy
Creator III
Creator III

Hi Rgv,

i think you forgot to put  '-' Symbol am i right?

@ Priyanshi , this is the actual expression that RGV wants to convey you.

Count( {$<Priority={'High'}, Status  = {'*'}-{'Closed'}>} Distinct %CaseId )


Regards,

Ganesh.

Anonymous
Not applicable
Author

Hi,

Count( {$<Priority={'High'}, Status - ={'Closed'}>} Distinct %CaseId )


-= in above expression : is not equal to operator in set analysis is used to exclude data.

here in expression 'Closed' status records are excluded to calculate count of  Distinct %CaseId

ganeshreddy
Creator III
Creator III

Hi Priyanshi,

basically both expressions which are in this thread are same, counting distinct open case ids with high priority.

Thanks,

ganesh