Discussion board where members can learn more about Qlik Sense App Development and Usage.
I am showing a bar chart in qliksense where in one dimension and one measure is been used:
Dimension : System
Measure : we need to display which all Operations have not started last 48 hours by System.
I am using below Measure expression :
Count( distinct if(Isnull(StartDate),Operation,System))+(Count(distinct Operation)-Count(distinct IF ( NOT IsNull(if(
((Date(Date#(Timestamp(aggr(NODISTINCT Max(Date(StartDate)),Operation)),'MM/DD/YYYY hh:mm:ss TT'),'MM/DD/YYYY hh:mm:ss')) - (v48HoursAgo)) <'00',NULL(),
Now issue is for some of the cases its shows correct count value on Bar chart if we select any System filter but it some cases it doesn't show correct count value on bar chart.
Please check my expression measure where i am going wrong.