how to get the sub category in table column

[vishalgoud]

Hi all,

WHEN MRC_TYPE in ('MRC', 'MRC DISCOUNT', 'MRC REFUND', 'OCC', 'OTC', 'Data Pass','BOLT ON', 'Roaming Data Pass') then MRC_TYPE

in the above case statement which we are wirting in Qlikview (netezza code) , there is an other sub category coming for OTC which is underlined above.

how to bring that sub category of OTC as a main category like above..

any help on this is much appreciated. Thanks

[sunny_talwar]

check here

how to get the sub category in table column