APP layout

[#1]

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.

[MK9885]

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.

[rittermd]

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

[#4]

SQL 2 years worthy of data all by date

[#5]

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

[MK9885]

Create Month out of your Date field.

Use that month within your expression

As I mentioned above with individual expression for individual month?