Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

Bar chart shows value different on data point

Hi,

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(),

1
)
), Operation,System))
)

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.

  • for last 48hours i have created a variable as v48HoursAgo : Date(now()-2, 'MM/DD/YYYY hh:mm:ss') and used in expression

Please check my expression measure where i am going wrong.

Regards

 

Labels (2)
0 Replies