I have these fields in my database, PayRollYear and PayRollMonth and EMPNO.
I want to create a combo chart, that shows the count of employees in the present year vs the previous year. Present year would be a bar chart, and previous year would be a line chart, month being the dimension. Any ideas????
- Create a variable something like vMaxYear=max(Year).
- Another variable, PrevYear = vMaxYear-1
- Comcbo chart. 1 Dimension, Month; 2 Expressions:
Sorry this is Qlik Sense though. You cannot create variables as in Sense.