Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
swarup_malli
Specialist
Specialist

Meaning of -{0} inside set expression ?

Hello Fellow developers,

I was trying to get the meaning of - {0}, though i know - minus mean means  exclude when is used along with a column name , could some one explain me the meaning. I havee highlighted it in red.

COUNT({$<INDNUMBER={"=sum({<CYEAR=$(vCampaignYearSelected)},MasterCalendar.MonthName=>}DCDetails.TOTALDON )>0 and sum({<CAMPAIGNYEAR={$(=vCampaignYearSelected-1)},MasterCalendar.MonthName=>}DCDetails.TOTALDON )=0"} - {0},  CAMPAIGNYEAR=,MasterCalendar.MonthName=>}DISTINCT INDACCOUNTNUMBER)

Thx

SM

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Your advanced search used for the set modifier of INDNUMBER will return a set of INDNUMBERs where the two sum conditions are met, but whatever INDNUMBERs are returned, exclude 0 (zero) from the set.

View solution in original post

2 Replies
swuehl
MVP
MVP

Your advanced search used for the set modifier of INDNUMBER will return a set of INDNUMBERs where the two sum conditions are met, but whatever INDNUMBERs are returned, exclude 0 (zero) from the set.

swarup_malli
Specialist
Specialist
Author

Thank you, Swuel..