topic Re: Custom Current & Previous week Analysis in App Development

Custom Current & Previous week Analysis

kakani87 — Thu, 03 Nov 2022 02:57:34 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

Re: Custom Current & Previous week Analysis

SunilChauhan — Thu, 03 Nov 2022 08:01:53 GMT

Test:
Load * Inline [
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
];

Load *
,Previous(salesAmt) as PreviousSales

Resident Test order by Item,Week;

Drop table Test;

see the attached file

Re: Custom Current & Previous week Analysis

kakani87 — Mon, 07 Nov 2022 18:30:10 GMT

Hi sunil... Thanks for your response.

Actually my requirement is not like you have shared.

Let say my table should be displayed with Data as below posted sample data

Product|Currentweeksales|PreviousWeeksales X, 10, 6

Y, 6,7

Z, 8,9

Now assume current week is 40th & previous week is 39th.

If I filter data that should dynamically filter the data accordingly.

In general we go for set expressions followed by for current & Previous as shown

Current = Sum({<weeknumber={ ' $(=max( weeknumber) )'}>}sales )

Store variable as vPrevWeek= Max( Weeknumber)-1

Previous =Sum({<weeknumber={ ' $(=max( wvPrevWeek) )'}>}sales )

While there is a filter provided for weeknumber data as 40,39,38,37 ...

Now in my case user asked to enhance the filter with start date & end date of week in one filter to apply the filter accordingly while I did that by doing work around like weekstart ( Trandate )&"-"weekend(Tran date ) As weekrange in back-end script. While I use this as a filter in front end this is not filtering data for previous week

Same time I'm good with set expression using weeknumber but not using week filter as startdate&' '&enddate (d/m/y ) format

1/1/2022-1/7/2022

1/8/2022-1/14/2022

1/15/2022-1/21/022

Hope you got my expectation .