Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression Value Missing for some rows

1.) I have a lookup table used for assigning bucket values based on a calculated percentage. A bucket is assigned based on whether it falls in between the low and high range.

BucketLow RangeHigh RangeStart DateEnd Date
A95991/1/20147/18/2014
B9094.9991/1/20147/18/2014
C8089.9991/1/20147/18/2014
D5079.9991/1/20147/18/2014
E049.9991/1/20147/18/2014

2.) The 2 relevant columns on my report are Compliance % and Bucket. I am using a "Straight Table" by the way.

      My Bucket expression is defined as so (vEndDate is a variable that is set to 03/15/2014):

  = if ( $(vEndDate) >= DATE(START_DATE) AND $(vEndDate) <= DATE(END_DATE),

     if( [Compliance %] >= LOW_RANGE AND [Compliance %] <= HIGH_RANGE, BUCKET)

     )

3.) I am having a weird issue where a bucket value is displayed correctly for some rows and for other is does not for some reason.

Sample Output:

 

Compliance %Bucket
98.931A
98.940A
98.302 -
97.256 -

Not sure where the problem is - I don't see any particular pattern in the rows that have a bucket value vs the others that do not.

0 Replies