Transform Dimmension on the script

[pgalvezt]

Hi, I have created a model with many formulas. This formulas works fine in my dimmension calculated and my expressions. The bad thing is Im not have enough RAM into my pc so the formulas getting to slow to QlikView. I have trid to export all my formulas into my script but for any reason doesn't result. I don't understand why my variable works fine into my dimmension calculated ad my expressions but not into my script. Please if any knows how to fix this problem would be great. I put attached file Qlikview and jpg.

Thank you.

[daveamz]

Hi,

I can't tell for sure what is wrong as I can't reload the data, but there is something strange with the:

LET vDate = date(date#(DD/MM/YYYY));

this expression will not create any variable.

what are you trying to calculate with: sum(date(Date#('$(vDate)'))-TD_Mora) ?

[pgalvezt]

Hello,

date(Date#('$(vDate)')) = Cut date (Where the user choose the date and realease the calc with TD_Mora)

So if the user choose for example 31/07/2012. All field (TD_Mora will be calculated with 31/07/2012)

So If 31/07/2012 - 20/07/2012 = 9 Days this value (9) I put into the stratification.

[pgalvezt]

Hello,

date(Date#('$(vDate)')) = Cut date (Where the user choose the date and realease the calc with TD_Mora)

So if the user choose for example 31/07/2012. All field (TD_Mora will be calculated with 31/07/2012)

So If 31/07/2012 - 20/07/2012 = 9 Days this value (9) I put into the stratification.

[daveamz]

I see, in this case you have to use the expression within the chart/pivot table since you will assing the value to this variable after loading the data.

[pgalvezt]

Hi, Yes if you take a look into my EX1 file you'll see the code that I replace for the dimmension.