Qlikview version of sql

[#1]

What is the qlikview version of this below SQL Query?

CASE WHEN ROI_NBR_SESSIONS_2013.ITEM_ID LIKE '%CB%' THEN

LTRIM(SUBSTR(ROI_NBR_SESSIONS_2013.ACCOUNT_NO,3,8),0)||'-' ||

LTRIM(SUBSTR(ROI_NBR_SESSIONS_2013.ACCOUNT_NO,11),0)

Thanks in adavnce.

[bbi_mba_76]

Hi,

it seems to be a sql server query.

For example || is the concatenation in sql server, whereas in qlikview you concatenate using the & char.

[hic]

Use If(,,) instead of CASE

Use WildMatch(...,'*CB*') instead of LIKE '%CB%'

Use Mid() instead of SUBSTR()

Use & instead of | |

LTrim exists in QlikView also, but cannot take a second parameter.

HIC