Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Change in Values

TABLE1:

   

IdNameStatusRiskDate
100ABCOpenLow10/1/2014
100ABCClosedMedium3/2/2014
200DEFOpenLow1/1/2015
200DEFOpenMedium1/2/2015
200DEFClosedHigh1/3/2015
300XXXOpenHigh5/6/2015
300XXXOpenLow7/7/2015
300XXXClosedHigh8/9/2015
400YYYOpenLow1/2/2015
400YYYClosedMedium2/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?

5 Replies
trdandamudi
Honored Contributor

Re: Change in Values

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

florentina_doga
Contributor III

Re: Change in Values

hy

hope this help

Not applicable

Re: Change in Values

Any further Ideas please can anyone help ?

Not applicable

Re: Change in Values

Hi

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

Hi,

Can you post the expected output for your posted table?

Community Browser