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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

SubStringCount wrong display

Hi All

In attached example I want to see actual quarter like 'Q4-14' etc rather than stupid values. Can somebody help me please?

In Red is not sorted

Instead of 20,3,3,5,4 I need Q4-14, Q1-15 and so on

Capture.PNG

Thanks

1 Solution

Accepted Solutions
sunny_talwar

Attaching your application for reference also.

Best,

Sunny

View solution in original post

4 Replies
sunny_talwar

Use this instead:

='1 is:  ' & SubField(Concat(Values, '|', Qtr), '|', 1)

HTH

Best,

Sunny

sunny_talwar

Attaching your application for reference also.

Best,

Sunny

MK_QSL
MVP
MVP

='1 is:  ' & SubField(Concat(Values, '|',Qtr), '|',1)

='2 is:  ' & SubField(Concat(Values, '|',Qtr), '|',2)

and so on

JonnyPoole
Former Employee
Former Employee

in addition to above, you may also need  DISTINCT clause in concat:     concat(  distinct   ....  )  so that the values don't repeat for every row of data.