COUNT on IF Condition - PLZ HELP

Wed, 24 Jul 2013 12:29:02 GMT

Hi..

I want to identify NEW COPPER count based on the condition when CONNECT DATE >= RFS_DATE + 10 and ENTITY_TYPE = 'Copper' . The NEW COPPER count is mapped to chart.

written code:

COUNT (IF ((( Date(Date(Date#(REGION.RFS_DATE, 'MM-DD-YYYY'), 'MM-DD-YYYY') + 10, 'MM-DD-YYYY')) <= SERVICE_TRACKING.CONNECT_DATE

AND SERVICE_TRACKING.ENTITY_TYPE = 'Copper', (SERVICE_TRACKING.ENTITY_TYPE)))

I have attached the report screenshot document for reference.

I also identify TOTAL COPPER Count based on one more filter condition ie,

IF (SERVICE_TRACKING.ENTITY_TYPE = 'Copper', (SERVICE_TRACKING.ENTITY_TYPE)). The TOTAL COPPER count is mapped to chart.

The problem here is, When i click on the NEW COPPER option in a list box it would populate NEW COPPER and TOTAL COPPER count. Here the count should be SAME for both NEW AND TOTAL COPPER. I am not getting the desired result. In the atached screen NEW COPPER is 8 AND TOTAL COPPER is 7.

Both the value should be 7, not sure where the issue is.

PLEASE HELP.

topic COUNT on IF Condition - PLZ HELP in QlikView

COUNT on IF Condition - PLZ HELP