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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dimesion field causing calculation issue

I want to create a chart which captures 2 metrics

Number of units loaded per month

Number of Hu's delayed per month

My problem is that delay month and load month are 2 different date fields and If i put the delay month as dimension I cannot get a total of loaded units in my chart.

Eg. attached. How do I achieve both these expressions but my x axis should say delay month only - i.e. I need the loaded units to be put in a set and be calculated for load month but display within month name of delay month.

At this point all my loaded Hu's will display by itself and not within the date month of delay month

help appreciated.

0 Replies