Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

markgraham123
Contributor II

Use group by with If condition

Hi All,

I'm trying to create a flag by comparing Req vs actuals:

If Actual is less than Req for atleast 1 SubID - grouped by ID, then 'Check' else 'Good'

Please see attachment.

Any help is highly appreciated.

IDSubIDReqActual
1a10
1b22
2c33
2d44
3e55

Req: O/P;

 

IDSubIDReqActualFlag
1a10Check
1b22
2c33Good
2d44Good
3e55
1 Reply
antoniotiman
Honored Contributor III

Re: Use group by with If condition

Hi Mark,

why ID 3 isn't  'GOOD' ?