4 Replies Latest reply: Apr 10, 2017 9:55 AM by Neill Carson RSS

    Static Baseline Column

    Neill Carson

      Hi, I'm new to qlik and trying to learn as I go.

       

      I have a spreadsheet of Data, with a date column named "DisDate"  having information from 1/1/2015 to 4/6/2017 (in mm/dd/yyyy format)

      I am trying to build a combo chart where the first column will be a baseline (average of data from 1/1/2015 to 12/31/2015), then the next columns will be the months after MM/YYYY. Each column will be a count of account activity for that month (from a column labeled PatAcc).

       

      I know there are many experts here and I appreciate any help someone can provide.

       

      Thanks