Current and Previous values in UI

[Anonymous]

     Dear Guys,

Need help with the below requirement in UI.

a) Current values are the maximum values in table.

b) For previous values I need a option in UI to compare with current date and limit provided. (For eg: if I select 15, previous value should be compared between max date to 15th of that particular month)

Input:

Name	Row ID	Employee ID	last_modified_date_time	SLA	OTD
A	44	22	31/10/2017 23:45
B	44	22	15/11/2017 16:38	green
C	44	22	14/11/2017 17:32	green	3
D	44	22	15/11/2017 17:34	green	3
E	44	22	15/11/2017 17:36	green	3
F	44	22	17/11/2017 17:39	red	3
G	44	22	22/11/2017 12:34	red	3

Output:

Row ID	Name	prev_perfro	curr perf	prev_control_status	current_control status	changed date	prev chagened date
44	G	green	red	3	3	22/11/2017 12:34	15/11/2017 17:3

Note:

[sunny_talwar]

This is def. doable using set analysis, but how are you providing the limit? Is this via an input box?

[Anonymous]

Dear Sunny

Yes input will be provided via input box. Also the last modified date must be looked against Row ID and Employee ID (i.e Unique Row ID and Employee ID)

Thanks for your help.

[sunny_talwar]

Like the attached

[Anonymous]

Hi Sunny,

Yes Exactly. Can you share me the file please.

[sunny_talwar]

It is already attached above

[Anonymous]

Hi Sunny, I can see Image alone. Can you please share the qvw file ?

[sunny_talwar]

Open this link

Re: Current and Previous values in UI

[Anonymous]

Thanks Sunny.

Have checked the file. It has current selections populated as per the date selected in list box. May be I am not clear with my requirement here.

Please find below in detail.

• Key=Row ID+Employee ID
• Only Columns with Previous (i.e. Previous OTD and Previous last_modified_date_time) must be picked from previous values, other column values must be current values.
• The output tables must be shown for selected month only. Here Nov 2017 is selected. So record with 31/10/2017 23:45 is not populated in output table.

Source:

Name	Row ID	Employee ID	last_modified_date_time	SLA	OTD	FPR	Priority
A	74	22	31/10/2017 23:45			Yes	1
B	44	22	15/11/2017 16:38	green		Yes	2
C	44	22	14/11/2017 17:32	green	3	Yes	1
H	11	44	17/11/2017 17:32	red	4	No	1
E	33	23	15/11/2017 17:39	green	3	Yes	2
E	44	22	15/11/2017 17:38	green	1	No	3
E	44	22	15/11/2017 17:36	red	3	No	2
F	33	23	17/11/2017 17:39	red	3	No	1
G	44	22	22/11/2017 12:34	red	3	No	2
H	11	44	25/11/2017 12:34	green	4	No	1

Output Table (vInput=15):

Row ID	Name	Employee ID	Previous SLA	Current SLA	Previous OTD	Current OTD	Current last_modified_date_time	Previous last_modified_date_time	FPR	Priority
44	G	22	green	red	1	3	22/11/2017 12:34	15/11/2017 17:38	No	3
33	F	23	green	red	3	3	17/11/2017 17:39	15/11/2017 17:39	No	1
11	H	44	red	green	4	4	25/11/2017 12:34	17/11/2017 17:32	No	1

Output Table (vInput=17):

Row ID	Name	Employee ID	Previous SLA	Current SLA	Previous OTD	Current OTD	Current last_modified_date_time	Previous last_modified_date_time	FPR	Priority
44	G	22	green	red		3	22/11/2017 12:34		No	3
33	F	23	green	red		3	17/11/2017 17:39		No	1
11	H	44	red	green	4	4	25/11/2017 12:34	17/11/2017 17:32	No	1

[Anonymous]

Dear Sunny, Any help or suggestions on this please.