topic Re: Select Top Five Files but what about spaces? in QlikView

Select Top Five Files but what about spaces?

rustyfishbones — Fri, 13 Feb 2015 10:58:08 GMT

Hi All,

I have the following expression used in a Select in Field to Select the 5 biggest files based on File Size

'(' & CONCAT(IF(AGGR(RANK(SUM(Size)),[Full Path])<=5,[Full Path]),'|') &')'

however it does not work, I believe it's because there are spaces in the Full Path name

What can I add to the above expression to resolve it

Regards

Alan

rustyfishbones — Fri, 13 Feb 2015 10:59:18 GMT

btw

the expression returns the correct result and shows me the 5 files, however it does not select them

Regards

Alan

marcus_sommer — Fri, 13 Feb 2015 13:19:43 GMT

Maybe you need each value wrapping in single/double-quotes, like:

'(' & chr(39) CONCAT(IF(AGGR(RANK(SUM(Size)),[Full Path])<=5,[Full Path]), chr(39) & '|' & chr(39)) & chr(39) &')'

- Marcus

rustyfishbones — Fri, 13 Feb 2015 13:34:46 GMT

I was thinking of that too but it does not work

rustyfishbones — Fri, 13 Feb 2015 13:36:27 GMT

Actually, I just replaced CHR(39) with CHR(34)

And it worked

So the working Expression is

='(' & chr(34) & CONCAT(IF(AGGR(RANK(SUM(Size)),[Full Path])<=5,[Full Path]), chr(34) & '|' & chr(34)) & chr(34) &')'