Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Conditional Expression column display

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


3 Replies
Anonymous
Not applicable
Author

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

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

maxgro
MVP
MVP

better to use a fixed length field

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

ramoncova06
Partner - Specialist III
Partner - Specialist III

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

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