topic Re: Transform a expression to dimension in QlikView

Transform a expression to dimension

Anonymous — Thu, 21 Nov 2013 14:01:58 GMT

I need to transform this espression to dimension

if([Vta Acum]<=0.5,'A',if([Vta Acum]<=0.8,'B',if([Vta Acum]<=0.9,'C',if([Vta Acum]<=0.95,'D',if([Vta Acum]<=0.98,'E','F')))))

Regards

CAP

Re: Transform a expression to dimension

Anonymous — Thu, 21 Nov 2013 14:14:41 GMT

Carlos,

You can use your expression as a calculated dimension.

Re: Transform a expression to dimension

Anonymous — Thu, 21 Nov 2013 14:18:30 GMT

Carlos

You may wish to think about doing this in the load script and create a new field called say [VTA Group].

Best Regards, Bill

Re: Transform a expression to dimension

Anonymous — Thu, 21 Nov 2013 14:30:46 GMT

i wil try, i keep in touch soon.

Thanks

Re: Transform a expression to dimension

MayilVahanan — Thu, 21 Nov 2013 14:36:02 GMT

If you use calculated dimension, may be its take time to load the widgets, if you have huge data in it. So please create new field in script for tat, instead of using calculated dimension.

Hope tat helps