Discussion Board for collaboration on QlikView Scripting.
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)=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,
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:
I think if you add that to your calculated dimension, it should yield a result.
Hope this helps
Sorry, its (Sum , but don't work either =/ 'exceeded the memory'
If that doesn't help then you can do something like this in the script:
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,
LOAD Sum/Count/Max/Min (totalCategoriasKpi) as SumtotalCategoriesKpi,
Group By id_master;