Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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

7 Replies
zebhashmi
Specialist
Specialist

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
Not applicable
Author

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

KPIsCurrent MonthLast Month
Visits????
Orders ????
Units ????
Revenue????
zebhashmi
Specialist
Specialist

Sorry for Late reply

You can do something like that

Capture1.PNG

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
Not applicable
Author

Thanks zebhashmi

VishalWaghole
Specialist II
Specialist II

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)

292966.JPG

Anonymous
Not applicable
Author

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.