Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
Hi,
one solution could be:
hope this helps
regards
Marco