5 Replies Latest reply: Dec 14, 2016 3:52 PM by Shahbaz Khan Mohammed 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
          Shahbaz Khan Mohammed

          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';