topic table in QlikView

table

lionking15 — Wed, 25 Nov 2020 16:16:04 GMT

i am having a table consist of fields Customer,sales id,sales,ShipDate,product,quantity and i have linked ShipDate to master calender.

and the issue is that i have to create

straight table having below expressions

Current Year Sales, Previous Year Sales, Current Month Sales, Previous month Sales and product as dimension

means if i select particular year and month i should get corresponding Current Year Sales, Previous Year Sales, Current Month Sales, Previous month Sales

thanks!!!!!!!!

Re: table

saimahasan — Tue, 02 Aug 2016 12:38:45 GMT

When you say Previous Year Sales and Previous Month Sales, do you mean the Sales for the Entire previous year or only for the selected Month for the Previous Year??

Similarly, when you say previous months sales, do you mean all years sales for that month or only the sales for the month selected in previous year??

Like, if you select year as 2016 and month as Jun,

Previous Year Sales = Sales of entire 2015 or Sale of May 2015??

Previous Month Sales = Sale of may for every year or sales of May 2015