Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
walimmalik
Contributor
Contributor

Calculated Field in Bar Chart

Hi,

I want to create a bar chart that shows the number of on time/late activities per department.  I have 3 fields, [department], [planned finish date], and [actual finish date]. I was wondering if there was a way on the fly in the field expression to calculate a total count of late and on time activities by an if statement like if([actual finish date] - [planned finish date] > 0, 'Late', 'On time').  I would like to do this without having to add a calculated field in my data manager section.

thanks.

0 Replies