Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

buzzy996
Honored Contributor II

calculated dimension expression issue

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

32 Replies
Not applicable

Re: calculated dimension expression issue

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
Esteemed Contributor III

Re: calculated dimension expression issue

count(distinct  num)

what is unique?

Not applicable

Re: calculated dimension expression issue

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

It is much quicker and the way to do it.

Re: calculated dimension expression issue

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
Honored Contributor II

Re: calculated dimension expression issue

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
Honored Contributor II

Re: calculated dimension expression issue

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

Re: calculated dimension expression issue

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
Honored Contributor II

Re: calculated dimension expression issue

received No data to display.

not worked.

any help?

Re: calculated dimension expression issue

this?


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