cal example

[#1]

hello

I need some suggestions or help on calcuated dimesion

My req is i have two columns and i need to merget them based on certain condition

please look into the attached image and qvw for suggestion.

need help

[#2]

suggestion pls

[cjohnson]

Hi,

Following would be your calculated dimensions (I didn't continue, but you get the idea - just follow along with the match functions as necessary):

Consider doing this in the script - that would eliminate the need of a calculated dimension. So I would try to push these fields back into the script.

For example, create a whole new field based off of your existing dimensional fields. It would use the same functions as above - but you would just alias them to a new field. That way you eliminate the use of a calculated dimension and it will be better - performance-wise.

Thanks,

Camile

[#4]

Thanks Camile for your response

Unfortunately i tried to add the expressions in the chart but unfortunately it was throwing out of memory expception

Could you please share me the app?

I just need to check my mistake , hope it would be fine

could you please send me the app?

[cjohnson]

Here it is attached.

I just want to suggest again to push these calculations back to the script - if possible. You do this by creating a new field in the script with the same expression.

[#6]

Hello Camile

Thanks for the app but unfortunately i could same error in your qvw too... i am sharing the image that i got after opening your dashboard. please look into it/ Could you please advise me?

[#7]

Just want to check .. is this a error or am i done anythign from my end ?

[cjohnson]

I'm not sure what is causing your issue. Maybe try to make a selection and clear again. Did you try doing that?

It works fine on my end. Also try putting it back into the script. Write the same expression as follows (in the script):

if(match(depot_code, 'AV', 'AVN'),  'AV, AVN',

  if(match(depot_code, 'FW', 'FWN'),  'FW, FWN',

  if(match(depot_code, 'HH', 'HHN'),  'HH, HHN',

  if(match(depot_code, 'S', 'SN'),  'S, SN',

  if(match(depot_code, 'TV', 'TVN'),  'TV, TVN',

  if(match(depot_code, 'V', 'VN', 'VT'),  'V, VN, VT',

  if(match(depot_code, 'BT', 'BTN'),  'BT, BTN',

  depot_code)))))))                         as NewDepotCodeField

Then use this new field as a dimension.

I'm presuming it has something to with your model, but I'm not sure...