Skip to main content
Product Release Webinar: Qlik Insider airing December 6! REGISTER TODAY!
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Result not included due to the value '-'

I have a column (xamt) that has a value of an amount, a  -0-, a null and sometimes a ' '.   The result of this shows '-' in qlikview.   If I try to select ranges of 0-100 using totusd, some records are not included because the value is '-'.  I

if ((cur)= 'USD',(xamt),((xamt)*(rt))) as totusd

1 Reply
Partner - Creator II
Partner - Creator II


Try this:

if (cur = 'USD', RangeMax(0, xamt), RangeMax(0, xamt) *rt) as totusd