topic Re: Change in Values in QlikView

Change in Values

Thu, 05 May 2016 13:24:36 GMT

TABLE1:

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

I would like to see where 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

How many Ids changes risks/ For a closed id in the above table - has the status changes since Open? A flag needs to be added to know rish changes or not(y/n)

Help me on the above?

Re: Change in Values

trdandamudi — Thu, 05 May 2016 13:36:34 GMT

It is not clear.. Can you give us an example with the output you are expecting...

Re: Change in Values

florentina_doga — Thu, 05 May 2016 13:41:19 GMT

hope this help

Re: Change in Values

Thu, 05 May 2016 17:31:30 GMT

Any further Ideas please can anyone help ?

Re: Change in Values

Fri, 06 May 2016 06:28:59 GMT

The flag we can show it as yes or no

If the risk changes from open to closed we need display it as Yes as a Flag

Re: Change in Values

settu_periasamy — Fri, 06 May 2016 06:37:40 GMT

Hi,

Can you post the expected output for your posted table?