manipulate data based on dimension value.

Mon, 25 Oct 2010 13:07:40 GMT

Hello all,

I have a table and I want to manipulate its data based on the expression dimension value.

for example if my dimension value is "A" multipy the data by 100 and if the dimension value is "B" divide the data by 100.

any ideas can this be done?

I am think the best will be to manipulate the data on the loadscript so afterwards I will be easier to use them in different tables without having to write any complex formula every time.

Regards,

Savvas

manipulate data based on dimension value.

renjithpl — Mon, 25 Oct 2010 13:12:31 GMT

Hi Savvitos,

You can try something like this in the edit script

Sum(if(Dimension ='A', Value)) * 100 as XXX,

Sum(if(Dimension ='B', Value)) / 100 as YYY

Then you can select XXX or YYY in your dimensions.

Regards

topic manipulate data based on dimension value. in QlikView

manipulate data based on dimension value.

manipulate data based on dimension value.