topic Re: Last 5 week trends for comparing current week value vs last week value in QlikView

Last 5 week trends for comparing current week value vs last week value

deepakkrish — Sat, 16 Nov 2024 02:00:52 GMT

Hi All,

Great day for you ..

I want to calculate trends for last 5 week to comparing one value from last week vs Current week. below is my table.

I have a date field called time stamp this contains only Monday dates.

Data for 28/10/19

Timestamp	ID	stage
28th Oct 2019	1	qualified
28th Oct 2019	2	qualified
28th Oct 2019	3	qualified
28th Oct 2019	4	qualified
28th Oct 2019	5	qualified

Data for 04/11/19

Timestamp	Id	stage
4th Nov	1	propose
4th Nov	4	Propose
4th Nov	8	not
4th Nov	6	qualify
4th Nov	7	not

Now I have to compare how many stages moved qualified stage to proposed stage, So comparing last week data 28/10/19 there are 5 qualified and this week 2 changed to propsed stage ..so my result is 2/5 =0.4

This should be calculated for trends in last 5 week.

please suggest some ideas to solve this task..

Regards,

Krish.

Re: Last 5 week trends for comparing current week value vs last week value

Arthur_Fong — Thu, 07 Nov 2019 08:09:42 GMT

I build this at script level:

Refer qvw attached as reference.

Thanks and regards,

Arthur Fong

Re: Last 5 week trends for comparing current week value vs last week value

deepakkrish — Thu, 07 Nov 2019 09:25:37 GMT

Hi Arthur,

Thanks for your reply , For some reason I cant try this in script side . can you help me to do this in script side .

Regards,

Krish.

Re: Last 5 week trends for comparing current week value vs last week value

Arthur_Fong — Thu, 07 Nov 2019 09:27:20 GMT

The qvw i shared is built in script already.

Re: Last 5 week trends for comparing current week value vs last week value

deepakkrish — Thu, 07 Nov 2019 09:49:18 GMT

The record count is more and I cant run any scripts on back end now .. Expecting this should be done on chart side , rather case i have to go with excel sheet.. so I am trying to get this to be in front end.

Regards,

Krish.

Re: Last 5 week trends for comparing current week value vs last week value

simrankaur — Thu, 07 Nov 2019 11:13:39 GMT

Please find the ans in the qvw attached.

Re: Last 5 week trends for comparing current week value vs last week value

deepakkrish — Thu, 07 Nov 2019 12:33:14 GMT

Thanks for your reply .. Do you have any idea to implement this in chart using set analysis or any condition?

Re: Last 5 week trends for comparing current week value vs last week value

simrankaur — Wed, 13 Nov 2019 07:27:41 GMT

I worked on it and it cannot be done completely on UI because you cannot call two different dates on the same row but you will have to make a little adjustment in script to make it work on UI.

This has the minimal backend work which has to be done to solve your problem.