topic Re: Qlikview version of sql in QlikView

Qlikview version of sql

Wed, 11 Dec 2013 15:39:10 GMT

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 — Wed, 11 Dec 2013 16:43:55 GMT

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 — Wed, 11 Dec 2013 17:22:31 GMT

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