Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Master II
Master II

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

florentina_doga
Partner - Creator III
Partner - Creator III

hy

hope this help

Not applicable
Author

Any further Ideas please can anyone help ?

Not applicable
Author

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

settu_periasamy
Master III
Master III

Hi,

Can you post the expected output for your posted table?