topic Conditional Expression column display in QlikView

Conditional Expression column display

Anonymous — Tue, 14 Apr 2015 16:27:40 GMT

Hi All

I am facing problem with conditional statement when QUARTER exceed than 9 (10, 11, 12, ...).

QUARTERS are number.

=SubStringCount(Concat(QUARTER, '|'), 11)

If anybody know alternative for this?

Thanks

Anonymous — Tue, 14 Apr 2015 16:30:53 GMT

Not clear what the problem is. From your description, it could be

if(QUARTER>9, <result if true>, <result if false>)

maxgro — Tue, 14 Apr 2015 18:17:29 GMT

better to use a fixed length field

or change QUARTER to num(QUARTER,'000')

ramoncova06 — Tue, 14 Apr 2015 21:00:51 GMT

you could assign an ID to the Quarter and then replace it in your substring count

=SubStringCount(Concat(QUARTER_ID, '|'), 'ID_11')