Latest Month Rate Compare to Previous Month

[FULO1251]

Hi QlikView Users,

I am a newbie to QlikView and am looking for some help with my dashboard in order to compare latest month product rate with previous month product rate. I am also having issue with getting the master calendar working.

I would also like to add indicators to compare both so that if there is an increase from last month then I get red arrow up, if decrease a green arrow down.

I have attached my data. I would really appreciate any help this forum can offer.

[Saravanan_Desingh]

Are you looking something like this?

tab1:
LOAD [Shop Name], 
     Date(MonthStart(Floor([Purchase Date]))) As [Purchase Date], 
     [Product Name], 
     Product.IsValid
FROM
[C:\Users\sarav\Downloads\Data.xlsx]
(ooxml, embedded labels, table is Data);

tab2:
LOAD [Month-Year] As [Purchase Date], 
     [Total Sales]
FROM
[C:\Users\sarav\Downloads\KPI.xlsx]
(ooxml, embedded labels, table is Sheet1);

PuDate:
LOAD DISTINCT [Purchase Date]
Resident tab1;

Concatenate(PuDate)
LOAD DISTINCT [Purchase Date]
Resident tab2;

Cal:
NoConcatenate
LOAD AddMonths(MinDate,IterNo()-1) As [Purchase Date]
While AddMonths(MinDate,IterNo()-1)<=MaxDate
;
LOAD Date(Min([Purchase Date])) As MinDate,
	 Date(Max([Purchase Date])) As MaxDate
Resident PuDate;

Left Join(Cal)
LOAD DISTINCT [Product Name]
Resident tab1;

Concatenate(tab1)
LOAD * Resident Cal;

Drop Table PuDate, Cal;

[Saravanan_Desingh]

Dimensions: Product Name, Purchase Date

Expressions

Month Sales: Count(Product.IsValid) 
Diff: [Month Sales]-Above([Month Sales])

: 

[Brett_Bleess]

If Saran's posts helped you with what you needed, we would appreciate it if you would close the thread by using the Accept as Solution button on the post(s) that helped.  If you require further assistance, please leave an update post.

Regards,
Brett