How can I write this in Qlikview.Please help me

[#1]

WHEN ROI_NBR_SESSIONS_2013.ITEM_ID IN ('L_R6R7','L_R7','LR_R6R7')

[Nicole-Smith · Accepted solution]

where match(ROI_NBR_SESSIONS_2013.ITEM_ID,'L_R6R7','L_R7','LR_R6R7')

[#3]

Thank you Nicole

[#4]

Nicole,

Can you help me with this one ?

WHEN ROI_NBR_SESSIONS_2013.ITEM_ID = 'LR_R6R7'

AND (ROI_NBR_SESSIONS_2013.ACCOUNT_NO LIKE '00074%'

   OR ROI_NBR_SESSIONS_2013.ACCOUNT_NO LIKE '00075%'

    OR ROI_NBR_SESSIONS_2013.ACCOUNT_NO LIKE '0008%')

Thank you for your time.

[Nicole-Smith]

WHERE ROI_NBR_SESSIONS_2013.ITEM_ID = 'LR_R6R7'

AND WILDMATCH(ROI_NBR_SESSIONS_2013.ACCOUNT_NO, '00074*', '00075*', '0008*')