Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Count( {$<Priority={'High'}, Status - ={'Closed'}>} Distinct %CaseId )
What does ' - ' sign (after status) indicate? Could anyone please help me out with this?
Thanks
'-' sign indicates negation here. I.e. all status which are NOT 'Closed'.
count distinct %CaseId where Status in not 'Closed' and having 'High' Priority
hth
Sasi
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)
Hi,
It will exclude the Closed Status from Counting.
-= -- Negates (ignores) the given values
Regards,
Jagan.
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
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
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.
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
Hi Priyanshi,
basically both expressions which are in this thread are same, counting distinct open case ids with high priority.
Thanks,
ganesh