Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Transform a expression to dimension

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

4 Replies
Highlighted
Champion III
Champion III

Re: Transform a expression to dimension

Carlos,

You can use your expression as a calculated dimension.

Highlighted

Re: Transform a expression to dimension

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

Highlighted
Contributor II
Contributor II

Re: Transform a expression to dimension

i wil try, i keep in touch soon.

Thanks

Highlighted

Re: Transform a expression to dimension

Hi

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