topic Re: SubStringCount wrong display in QlikView

SubStringCount wrong display

Anonymous — Thu, 26 Mar 2015 19:45:54 GMT

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

Thanks

sunny_talwar — Thu, 26 Mar 2015 19:54:55 GMT

Use this instead:

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

HTH

Best,

Sunny

sunny_talwar — Thu, 26 Mar 2015 19:57:00 GMT

Attaching your application for reference also.

Best,

Sunny

MK_QSL — Thu, 26 Mar 2015 19:57:46 GMT

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

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

and so on

JonnyPoole — Thu, 26 Mar 2015 20:01:52 GMT

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.