Qlik Sense: Dual () function returns different result in Table object compared to Bar or Line chart"Article Number: 000059860 | Last Modified: 2019/01/24
But when the same expression is used in Bar Chart, Line Chart, or Gauge etc.., it returns Sum(Margin)/sum(Cost).
The result should be identical in all objects.
- Qlik Sense Qv12.20
It is a degrade bug found in both QlikView and Qlik Sense. It worked in QV11.20 but not in QV12.20 (and onwards).
- The numbers displayed in a Table (Qlik Sense) are the correct result. Note that Dual() returns same value as Sum(Margin).
- Bar Chart, Line Chart, Gauge etc.. do not display the dual values correctly on the data point. Note, on DataPoints, we have Sum(Margin)/Sum(Cost)
Have a Question?
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.