Create a Flag

[#1]

  T1:  

Id	Name	Status	Risk	Date
100	ABC	Open	Low	10/1/2014
100	ABC	Closed	Medium	3/2/2014
200	DEF	Open	Low	1/1/2015
200	DEF	Open	Medium	1/2/2015
200	DEF	Closed	High	1/3/2015
300	XXX	Open	High	5/6/2015
300	XXX	Open	Low	7/7/2015
300	XXX	Closed	High	8/9/2015
400	YYY	Open	Low	1/2/2015
400	YYY	Closed	Medium	2/2/2015
500	ZZZ	Open	Low	2/3/2015
100	ABC	Closed	High	3/5/2014
100	ABC	Closed	Medium	3/3/2014
200	DEF	Closed	Low	1/4/2015

I have a Table T1 with above mentioned data

we need to show the Risk  for a Id changes from when we first receive the Id's risk  in the above table to when their Status changes to Closed

A flag needs to be added to know risk changes or not

Output:

Id	Name	Status	Risk	Date	Risk_Flag
100	ABC	Open	Low	10/1/2014	N
100	ABC	Open	Medium	3/2/2014	Y
100	ABC	Open	High	3/5/2014	Y
100	ABC	Closed	Medium	3/6/2014	Y
200	DEF	Open	Low	1/1/2015	N
200	DEF	Open	Medium	1/2/2015	Y
200	DEF	Open	High	1/3/2015	Y
200	DEF	Closed	Low	1/4/2015	Y
300	XXX	Open	High	5/6/2015	N
300	XXX	Open	Low	7/7/2015	Y
300	XXX	Closed	High	8/9/2015	Y
400	YYY	Open	Low	1/2/2015	N
400	YYY	Closed	Medium	2/2/2015	Y
500	ZZZ	Open	Low	2/3/2015	N

Please help me to get the above output.

[#2]

ID	Fixed	Status	Test_Date	values	Date
100	N	approved	8/8/2016	Text	8/8/2016
200	N	approved	26/05/2016	Text1	26/05/2016
300	N	approved	27/05/2016	Text1	27/05/2016
400	N	approved	10/10/2016	Text1	10/10/2016
500	N	Reject	10/12/2016	Text4	10/12/2016
500	Y	Reject	10/12/2016	Text4	10/13/2016

three bar charts can be displayed on below 3 conditions

1)Where Status = approved

Fixed = 'N'

today date is greater than the Test_Date-60   (bar chart)

2)Where status = approved

Fixed = 'N'

today date is is greater than the Test_Date  (bar chart)

3)Where Satus = Reject

Match where the role has Text4 (bar chart)
Could you please help on above three set expressions.

[sunny_talwar]

If this is a new requirement, I will urge you to close this thread by marking correct and helpful answers and create a new thread for this.

Qlik Community Tip: Marking Replies as Correct or Helpful