topic Re: cal condition example in QlikView

cal example

Wed, 07 Oct 2015 12:49:02 GMT

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

Re: cal condition example

Wed, 07 Oct 2015 13:15:07 GMT

suggestion pls

Re: cal condition example

cjohnson — Wed, 07 Oct 2015 13:30:00 GMT

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

Re: cal condition example

Wed, 07 Oct 2015 13:45:52 GMT

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?

Re: cal condition example

cjohnson — Wed, 07 Oct 2015 14:09:48 GMT

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.

Re: cal condition example

Wed, 07 Oct 2015 14:13:27 GMT

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?

Re: cal condition example

Wed, 07 Oct 2015 14:25:23 GMT

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

Re: cal condition example

cjohnson — Wed, 07 Oct 2015 14:52:37 GMT

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...