Can we showcase current month vs last month summary in Qlik Sense Pivot?

[Anonymous]

Hi Community,

I wan to showcase month over month summary in pivot table.

Can anyone help me with it?

Attached the sample data for reference.

Thanks!

Prashant

[zebhashmi]

I think we can. will you like share something you want to do.

[OmarBenSalem]

to not complicate things and use really EASY expressions let' sdo a follow:

as a dimension: Month

as a COLUMN: Year

a measure: sum(YourMeasure)

and u have what u need

[Anonymous]

This is what is want to view in the Qlik Sense Pivot table

KPIs	Current Month	Last Month
Visits	??	??
Orders	??	??
Units	??	??
Revenue	??	??

[zebhashmi]

Sorry for Late reply

You can do something like that

which date you will select it will give you the result

Dim

=ValueList('Visits','Orders','Units','Revenue')

Mes

=IF( ValueList('Visits','Orders','Units','Revenue') = 'Visits', sum(Visits), IF( ValueList('Visits','Orders','Units','Revenue') = 'Orders', sum(Orders), IF( ValueList('Visits','Orders','Units','Revenue') = 'Units', sum(Units), sum(Revenue))))

sec mes

=IF( ValueList('Visits','Orders','Units','Revenue') = 'Visits', sum({<Date={"$(=addmonths(Date,-1))"}>}Visits), IF( ValueList('Visits','Orders','Units','Revenue') = 'Orders', sum({<Date={"$(=addmonths(Date,-1))"}>}Orders), IF( ValueList('Visits','Orders','Units','Revenue') = 'Units', sum({<Date={"$(=addmonths(Date,-1))"}>}Units), sum({<Date={"$(=addmonths(Date,-1))"}>}Revenue))))

regards

[Anonymous]

Thanks zebhashmi‌

[VishalWaghole]

In QlikSense - Open Data Load Editor

Copy Paste below script, make sure your file path is correct.

CrossTable([KPI's], Data, 2)

LOAD Date,

MonthName(Date) as MonthData,

     Visits,

     Orders,

     Units,

     Revenue

FROM [lib://Desktop/Data.xlsx]

(ooxml, embedded labels, table is [K-12]);

and then create pivot table using Rows as your KPI's Field, Column is your MonthData Field Measure is Sum(Data)

[Anonymous]

Hi Jahanzeb,

Thanks for the solution but now i have one more issue, i want to showcase the MOM, QOQ and YOY based on same period of time.

E.g.: if suppose my QTD is giving the figures till current day(i.e. for 80 days) then Prv. QTD must give the figures for 80 days only(i.e from 1st Oct to 20th Dec). Similarly for MOM and YOY.