5 Replies Latest reply: Dec 14, 2016 3:52 PM by Aehman K RSS

    APP layout

    Robert Winkel

      Below is an example of the sheet I need.  I can not figure out how to do this in Qlik.

      I have tried pivot table but no luck.

      I need to display as below to display a trending by month for all the data on the left.

       

       

        • Re: APP layout
          Aehman K

          Those months you show are coming as an Expression.

          I'm not sure but if you can write individual expressions to show the months?

          Maybe like this...

          sum({<Your Dimension, Month={'Jan'} >}YourDimension)

          sum({<Your Dimension, Month={'Feb'} >}YourDimension)

          sum({<Your Dimension, Month={'Mar'} >}YourDimension)....

           

          I do not know any other way to show it in different columns, as Month is a dimension as well.

          • Re: APP layout
            Mark Ritter

            It really will depend on your data and how it gets loaded as to what approach you take.

              • Re: APP layout
                Robert Winkel

                SQL 2 years worthy of data all by date

                • Re: APP layout
                  Robert Winkel

                   

                  LIB CONNECT TO 'pharmoresql production (pharmore_rwinkel)';

                  Billing:
                  LOAD DayName(Billed) as Billed,
                      PharmID,
                      FacID,
                      RxNo,
                      DispenseDt,
                      RoNo,
                      PatID,
                      NDC,
                      Qty,
                      MOP,
                      BillAmt,
                      BillMethod,
                      SentToAccpac,
                      OtherPayorAmt,
                      DrugLabelName,
                      InvCost,
                      PayAmt;
                  SQL SELECT Billed,
                      PharmID,
                      FacID,
                      RxNo,
                      DispenseDt,
                      RoNo,
                      PatID,
                      NDC,
                      Qty,
                      MOP,
                      BillAmt,
                      BillMethod,
                      SentToAccpac,
                      OtherPayorAmt,
                      DrugLabelName,
                      InvCost,
                      PayAmt
                  FROM FwReports.dbo.Billing

                  Where billed >= '2015-01-01'
                  and billed <='2016-08-31'
                  and FacId <> 'FORMS'
                  and FacId <> 'MSTR'
                  and FacId <> 'RETAIL'
                  and FacId <> 'SAMPLE'
                  and FacId <> 'TEST'
                  and FacId <> 'TEST#2'
                  and FacId <> 'TEST2'
                  and FacId <> 'TEST3'
                  and FacId <> 'TRLK'
                  and FacId <> 'stag';