topic Re: Transform Dimmension on the script in QlikView

Transform Dimmension on the script

pgalvezt — Tue, 31 Jul 2012 14:43:09 GMT

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.

Re: Transform Dimmension on the script

daveamz — Tue, 31 Jul 2012 14:58:36 GMT

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

Re: Transform Dimmension on the script

pgalvezt — Tue, 31 Jul 2012 15:05:14 GMT

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.

Re: Transform Dimmension on the script

pgalvezt — Tue, 31 Jul 2012 15:45:06 GMT

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.

Re: Transform Dimmension on the script

daveamz — Wed, 01 Aug 2012 06:17:27 GMT

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.

Re: Transform Dimmension on the script

pgalvezt — Wed, 01 Aug 2012 14:54:52 GMT

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