topic Re: calculated dimension expression issue in QlikView

calculated dimension expression issue

buzzy996 — Tue, 22 Mar 2016 09:10:15 GMT

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

Re: calculated dimension expression issue

Tue, 22 Mar 2016 09:13:15 GMT

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

Re: calculated dimension expression issue

Chanty4u — Tue, 22 Mar 2016 09:13:32 GMT

count(distinct num)

what is unique?

Re: calculated dimension expression issue

Tue, 22 Mar 2016 09:16:41 GMT

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

Kushal_Chawda — Tue, 22 Mar 2016 09:19:21 GMT

try this calculated dimension

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

Re: calculated dimension expression issue

buzzy996 — Tue, 22 Mar 2016 09:19:29 GMT

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?

Re: calculated dimension expression issue

buzzy996 — Tue, 22 Mar 2016 09:21:22 GMT

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

sunny_talwar — Tue, 22 Mar 2016 09:21:29 GMT

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')

Re: calculated dimension expression issue

buzzy996 — Tue, 22 Mar 2016 09:25:49 GMT

received No data to display.

not worked.

any help?

Re: calculated dimension expression issue

Kushal_Chawda — Tue, 22 Mar 2016 09:28:09 GMT

this?

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

Re: calculated dimension expression issue

buzzy996 — Tue, 22 Mar 2016 09:29:52 GMT

sunny, i replace the above expression,received "Allocated memory exceeded".

any help?

Re: calculated dimension expression issue

sunny_talwar — Tue, 22 Mar 2016 09:33:06 GMT

What about this:

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

Re: calculated dimension expression issue

Kushal_Chawda — Tue, 22 Mar 2016 09:38:23 GMT

or try using Valuelist function

Dim1: Supplier name

Dim1: Valuelist('SLAs Met','SLAs Not Met')

Expression:

Pick(match(Valuelist('SLAs Met','SLAs Not Met'),'SLAs Met','SLAs Not Met'),

Count(If(Networkdays(Scheduled_Send_Time__c,Delivery_Acknowledged_Time__c,$(ListOfHolydays))<'6',unique num)),

Count(If(Networkdays(Scheduled_Send_Time__c,Delivery_Acknowledged_Time__c,$(ListOfHolydays))>='6',unique num)))

Re: calculated dimension expression issue

Digvijay_Singh — Tue, 22 Mar 2016 09:46:14 GMT

Try to see the value of below section in text box and check how it is changing based on selection, you may get some new ideas -

Concat(Networkdays(Scheduled_Send_Time__c,Delivery_Acknowledged_Time__c,$(ListOfHolydays)),chr(13)

Re: calculated dimension expression issue

buzzy996 — Tue, 22 Mar 2016 10:25:21 GMT

same as above, no data to display.

Re: calculated dimension expression issue

sunny_talwar — Tue, 22 Mar 2016 10:26:03 GMT

Do you have a sample you can share?

Re: calculated dimension expression issue

Kushal_Chawda — Tue, 22 Mar 2016 10:26:19 GMT

Have you tried this?

Re: calculated dimension expression issue

buzzy996 — Tue, 22 Mar 2016 10:28:30 GMT

will try suny,if it's possible i'll share.

pls let me know,if u have any other way we can do?

Re: calculated dimension expression issue

sunny_talwar — Tue, 22 Mar 2016 10:29:32 GMT

Kush suggested ValueList above, I guess give that a try

Re: calculated dimension expression issue

buzzy996 — Tue, 22 Mar 2016 10:45:06 GMT

hi kush,sorry for the late reply..i tried this it not given the expected result and not allowed to select either SLAs Met or Not from legends as well.

any other way to do?