Skip to main content
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Bar chart shows value different on data point


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(

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

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



0 Replies