Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
count(distinct num)
what is unique?
I would rather do this in the script than a calculated dimension.
It is much quicker and the way to do it.
try this calculated dimension
=aggr(If(Networkdays(Scheduled_Send_Time__c,Delivery_Acknowledged_Time__c,$(ListOfHolydays))>='6','SLAs Not Met','SLAs Met'),[Supplier name])
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?
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
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')
received No data to display.
not worked.
any help?
this?
aggr(If(Networkdays(only(Scheduled_Send_Time__c),only(Delivery_Acknowledged_Time__c),$(ListOfHolydays))>='6','SLAs Not Met','SLAs Met'),[Supplier name])