Discussion Board for collaboration related to Creating Analytics for QlikView.
I am wondering if it is possible to have this type of if statement:
if (field_b between 0 and 100 than field_d = A), else if (field_b between 101 and 1000 than field_d = B), else if etc.
Can I do it in qlikview?
Many thanks in advance
Try like this
Load *, if(field_b >= and field_b <= 100, 'A', if(field_b >=101 and field_b <= 1000,'B','C')) as field_d from tablename;
Hope it helps