Custom Week Analysis

[kakani87]

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

@sunny_talwar 

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