Discussion Board for collaboration related to QlikView App Development.
In my report, i need to calculate Avg(), Min(), Max() and Median(). Without Median function, the table show the data as per the condition.
But while adding the Avg and Median function in the same chart neglect the condition present inside it and produce this garbage and null values. Garbage value for Avg () and Null value for Min(), Max(), Median().
When adding not isNull() function inside the Avg() or Median() produces correct output by eliminating.
May i know why this issue present and help me with the information you know about this.
When you see the Chart named "Median and Average Check ", you can see the null values present for the median function and garbage values for avg function.
But the same function created in different chart i.e., one chart "Average Check"contain only the avg function, it doesn't contain the garbage values. Same for the median, look at the chart "Median Check".