Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
pedlopes
New Contributor III

Create calculated dimension in script

Hi guys,

I have some problem with my calculated dimension.

I need put this calculated dimension in script because my pivot table exceeded the memory.

So my calculated dimension is:

=if(aggr((totalCategoriasKpi),id_master)=1 ,Dual('1',1),

     if(aggr((totalCategoriasKpi),id_master)=2 ,Dual('2',2),

     if(aggr((totalCategoriasKpi),id_master)=3 ,Dual('3',3),

     if(aggr((totalCategoriasKpi),id_master)=4 ,Dual('4',4), dual ('5+',5)))))

What kind of transformation i have to do put this calculated dimension in to the script?

Thanks in advance,

Pedro Lopes

3 Replies

Re: Create calculated dimension in script

First of all what kind of aggregation are you doing here? are you doing a Sum? Count? Min? Max?? you have not specified anything here:

=If(Aggr(Sum/Count/Max/Min(totalCategoriasKpi),.....

I think if you add that to your calculated dimension, it should yield a result.

Hope this helps

Best,

Sunny

pedlopes
New Contributor III

Re: Create calculated dimension in script

Sorry, its (Sum , but don't work either =/  'exceeded the memory'

Re: Create calculated dimension in script

If that doesn't help then you can do something like this in the script:

Join (yourFactTable)

LOAD If(SumtotalCategoriesKpi = 1, Dual('1', 1), If(SumtotalCategoriesKpi = 2, Dual('2', 2),           If(SumtotalCategoriesKpi = 3, Dual ('3', 3), If(SumtotalCategoriesKpi = 4, Dual('4', 4), Dual ('5+', 5))))) as Dimension,

          SumtotalCategoriesKpi,

          id_master;

LOAD Sum/Count/Max/Min (totalCategoriasKpi) as SumtotalCategoriesKpi,

          id_master

Resident yourFactTable

Group By id_master;

HTH

Best,

Sunny

Community Browser