topic Grade Change in QlikView

Grade Change

Thu, 18 Jun 2015 20:27:58 GMT

Hi Experts,

I do have a requirement where I need to get Product names that have been downgraded or upgraded based on grading difference,

Sample data is as shown below,

Prod	Grade	Date
A123	1	6/15/2014
A123	2	6/14/2014
A456	1	6/15/2014
A456	1	6/14/2014
A789	2	6/15/2014
A789	1	6/14/2014

output value should be A789 and A123 which is calculated based on difference of today's grading and yesterday's grading is not equal to 0

Re: Grade Change

Anonymous — Thu, 18 Jun 2015 20:38:08 GMT

Here is the script:

data:
LOAD Prod,
Grade,
Date
FROM
[https://community.qlik.com/thread/169068]
(html, codepage is 1252, embedded labels, table is @1);

left join load
Prod,
if(len(trim(only(Grade))), 'Not Changed', 'Changed') as Result
resident data
group by Prod;

Re: Grade Change

MarcoWedel — Thu, 18 Jun 2015 20:44:41 GMT

Hi,

one solution could be:

hope this helps

regards

Marco