Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.Join Us
Suppression of zero values is automatically disabled when these functions are used.
But if an Inter-record function like above() works fine when a field directly is used from the data model and enable 'suppress with zero'. However, when an expression inside the above function, it gives wrong results, which validates the statement made.
if(Region=23,RangeSum(above(TOTAL Data,1,22)), Data) - this works fine and gives right results.
However if(Region=23,RangeSum(above(TOTAL Column(1),1,22)), Data) doesn't works since we have used the expression 'Column(1)' here.
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.Submit a case
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.