Discussion board where members can get started with Qlik Sense.
I am working on putting together a line chart that shows the average monthly production per position.
The goal is to use this to analyse production targets and their relevance to each position.
I am currently using the following Expression
but getting inaccurate results.
Should I be writing an expression for each position?
With 12 departments and 10-15 positions per department that would take a while to write out.
My table looks like this:
"rate" AS Prod,
Last Name First,
Last Hire Date,
Load Dual(fYear-1 &'/'& fYear, fYear) AS FYear,
Dual(Month, fMonth) AS FMonth,
DUAL ('Quarter' & Ceil(fMonth/3), Ceil(fMonth/3)) AS FQuarter,
Load Year + IF(Month>=$(vFM), 1,0) As fYear,
Mod(Month-$(vFM),12)+1 As fMonth,
DUAL('Quarter' & Ceil(Month/3), Ceil(Month/3)) AS Quarter,
Year (visitdate) As Year,
Month (visitdate) as Month,
Week (visitdate) as Week
I also tried creating a new field called TOTALPROD using a preceding load but keep getting a script error when executing.
Any advice is greatly appreciated!
Go to Solution.
May be like
Dimension : Position
Could you give a small fragment of the original data in a tabular form and what do you want to get at the output?
I am looking to get a line chart that shows the average sales per month by position.
So in tabular form it would look like this: