Expression Grouping Problem

[#1]

Hi all,

I am stuck trying to group rejects by Rejects =1, Rejects =2, Rejects=3+ using the expression below. The expression returns the total count but users would like to see this broken down into the three categories above. Any suggestions would be appreciated. Thank you.

COUNT(REJECT_CDE) .

[#2]

Hi,

Do you need the count for the 3 Reject values?

try this:

Count({$<REJECT_CDE = {1}>} REJECT_CDE) // counts all reject_cde that's equal to 1
Count({$<REJECT_CDE = {2}>} REJECT_CDE) // reject_cde that's equal to 2
Count({$<REJECT_CDE = {">= 3"}>} REJECT_CDE) // counts reject_cde greater or equal to 3

Regards

[#3]

Thank you for your suggestion Ronald C. I see what you are doing, but I don't think I described my problem sufficiently. We have orders with rejects. Some have none, one, two, three. We are trying to group the orders by these number of rejects. For example,

Order Date #of Orders #Rejects Orders Rejected Once Orders Rejected Twice Orders 3+

The rejected once, twice and 3+ are the expressions I need. I hope this is more clear. Thanks again.

Don

Servicelink Pittsburgh Pa

[#4 · Accepted solution]

Don,

I made a simple app to try Ronald's solution and I think that it's usefull [View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Components.UserFiles/00.00.01.15.11.Posted/rejectCount.qvw]. Maybe I'm not understanding the problem well.

dd. //

[#5]

Thank you. That worked very well.