I have a straight table with an expression which basically just divides SALESQUANTITY by 3. I would like QLIKVIEW to only display the results for this expression if they are whole numbers, i.e.
If the results show
I only want the 4 and 2 to be displayed and the others hidden.
Is this possible?
A cleaner version of the same would be:
Play around with the floor(), frac(), and mod() functions until you find something that works.
Try this, it is working fine
I created a temp table like this
LOAD * INLINE [
and used the expression as below
if(Sales/3 = floor(Sales/3), Sales/3)
The straight table displays the No. 5 & 8 rows.