Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

prashant_harwal
New Contributor

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
Valued Contributor

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

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

OmarBenSalem
Esteemed Contributor

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

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

prashant_harwal
New Contributor

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

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

KPIsCurrent MonthLast Month
Visits????
Orders ????
Units ????
Revenue????
zebhashmi
Valued Contributor

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

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

prashant_harwal
New Contributor

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

Thanks zebhashmi

vishalwaghole
Valued Contributor II

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

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

prashant_harwal
New Contributor

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

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.

Community Browser