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
