Custom Week Analysis

kakani87 — Thu, 03 Nov 2022 03:01:11 GMT

I should implement a requirement using transaction date In Qlikview , can someone assist here?

Let say weekly analysis to be presented with week format as weekstart (date) &'-'& weekend (date ) i.e. 1/1/2022 - 1/7/2022 , 1/8/2022 - 1/14/2022 , 1/15/2022 - 1/21/2022 ... in a filter and that should display the data Accordingly.

In a chart show product wise | current week sales | Previous week Sales .

Note:- week format should be as weekstart& weekend as shown below

Week, salesAmt, Item

1/1/2022 - 1/7/2022 , 1000, p1

1/8/2022 - 1/14/2022 ,254,p1

1/15/2022 - 1/21/2022,345, p1

1/1/2022 - 1/7/2022 , 1630, p2

1/8/2022 - 1/14/2022 ,294,p2

1/15/2022 - 1/21/2022,845, p2

1/1/2022 - 1/7/2022 , 1050, p3

1/8/2022 - 1/14/2022 ,654,p3

1/15/2022 - 1/21/2022,545, p3

topic Custom Week Analysis in Reporting Service & Alerting

Custom Week Analysis