Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
priyanshi
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
Not applicable

Re: SET ANALYSIS

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

sasiparupudi1
Not applicable

Re: SET ANALYSIS

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

hth

Sasi

jontydkpi
Not applicable

Re: SET ANALYSIS

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
Not applicable

Re: SET ANALYSIS

Hi,

It will exclude the Closed Status from Counting.

-= -- Negates (ignores) the given values

Regards,

Jagan.

brunobertels
Not applicable

Re: SET ANALYSIS

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

rgvavihs
Not applicable

Re: SET ANALYSIS

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
Not applicable

Re: SET ANALYSIS

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.

neetha_p
Not applicable

Re: SET ANALYSIS

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
Not applicable

Re: SET  ANALYSIS

Hi Priyanshi,

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

Thanks,

ganesh