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

[#2]

Hi Shiva,

Is there a specific reason why you doing this as a dimension?

QlikView disagrees we calculated dimensions as it slows the model down a lot.

Regards,
Marius

[Chanty4u]

count(distinct  num)

what is unique?

[#4]

I would rather do this in the script than a calculated dimension.

It is much quicker and the way to do it.

[Kushal_Chawda]

try this calculated dimension

=aggr(If(Networkdays(Scheduled_Send_Time__c,Delivery_Acknowledged_Time__c,$(ListOfHolydays))>='6','SLAs Not Met','SLAs Met'),[Supplier name])

[buzzy996]

hi,tried earlier the above suggested one..it's not given expected result.

what is unique?--field name is unique num,exp:roll number.

any help?

[buzzy996]

hi,i'm aware and agree with u.

i do not have the classification on source level,it's bit difficult to modify on script..so using calculated dim.

thanks

[sunny_talwar]

I agree that you should probably do this in the script, but in case front end is the only option, can you try this:

=If(Networkdays(Only({1} Scheduled_Send_Time__c), Only({1} Delivery_Acknowledged_Time__c), $(ListOfHolydays)) >= '6', 'SLAs Not Met', 'SLAs Met')

[buzzy996]

received No data to display.

not worked.

any help?

[Kushal_Chawda]

this?

aggr(If(Networkdays(only(Scheduled_Send_Time__c),only(Delivery_Acknowledged_Time__c),$(ListOfHolydays))>='6','SLAs Not Met','SLAs Met'),[Supplier name])