calculated dimension expression issue

[buzzy996]

hi guys,

Dim1: Supplier name

Dim2: this is my calculated dimension "=If(Networkdays(Scheduled_Send_Time__c,Delivery_Acknowledged_Time__c,$(ListOfHolydays))>='6','SLAs Not Met','SLAs Met')"

expression is : Count(unique num)

Result: results are appearing good as per the expectation but when i tried to click on second dimension legend on chart either SLAs Met or SLAs Not Met, for example if I click on SLAs met it appearing all SLAs Met and 1 or 2 case results of SLAs Not Met as well!!!,so here SLAs Not met should't appear.

any help?

thanks

[buzzy996]

more detailed

                                                                                                       DAT               SST

Uhthoff  Gomez Vega & Uhthoff	Jondle Plant Sciences    USDIR NARR	739	02/03/2016 07:40	25/02/2016 08:00	5	5	SLAs Met
Uhthoff  Gomez Vega & Uhthoff	Jondle Plant Sciences    USDIR NARR	971	02/03/2016 07:40	18/02/2016 08:00	5	10	SLAs Not Met
Uhthoff  Gomez Vega & Uhthoff	Jondle Plant Sciences    USDIR NARR	972	02/03/2016 07:40	18/02/2016 08:00	5	10	SLAs Not Met

[sunny_talwar]

I think you missed the headers, I don't know what value belongs to which field

[Digvijay_Singh]

sunindia‌

Not sure but is this problem similar to below thread

Filtering on a calculated dimension | Qlik Community