topic Expression Grouping Problem in QlikView

Expression Grouping Problem

Thu, 21 Oct 2010 21:02:43 GMT

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) .

Expression Grouping Problem

Fri, 22 Oct 2010 05:17:24 GMT

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

Expression Grouping Problem

Fri, 22 Oct 2010 14:28:07 GMT

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

Expression Grouping Problem

Fri, 22 Oct 2010 14:54:03 GMT

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. //

Expression Grouping Problem

Fri, 22 Oct 2010 15:49:19 GMT

Thank you. That worked very well.