topic Which Condistion working in QlikView

Which Condistion working

kulasekhar — Fri, 09 Jun 2017 17:36:14 GMT

Hi All,

Greetings for the day!

I have bellow table.

LOAD * INLINE [

FACTORY_NAME,NUMBER, BASECUT

IND,1, IN_PRODUCTION

IND,2, TERMINATED

IND,3, IN_PRODUCTION

IND,3, TERMINATED

IND,4, IN_PRODUCTION

IND,5, TERMINATED

IND,6, IN_PRODUCTION

IND,7, TERMINATED

IND,8, IN_PRODUCTION

IND,8, TERMINATED

];

Condistion: When ever showing one NUMBER only IN_PRODUCTION then IN_PRODUCTION

When ever showing one NUMBER both IN_PRODUCTION and TERMINATED then IN_PRODUCTION

When ever showing one NUMBER only TERMINATED then TERMINATED

Please find the same table attached QVW.

Thanks

Sekhar.

antoniotiman — Fri, 09 Jun 2017 18:05:50 GMT

Hi Sekhar,

see Attachment.

Regrds,

Antonio

kulasekhar — Sat, 10 Jun 2017 03:02:54 GMT

Hi Antonio,

Can we write in script level. above solustion mine it's not working.

Thanks

Sekhar.

antoniotiman — Sat, 10 Jun 2017 05:42:52 GMT

See Attachment