Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a strange issue, I have a field in my sql database which holds values 1 and 0 but when I load into QV its showing me -1 and 0 how should I change to 1 and 0...Thanks
this is not a QV behaviour, but you can use fabs(field) to have absolute value so -1 will become 1
if(fieldname=-1,1,0) ?
By the way, boolean fields have -1 or 0 values, so it's not really strange.