topic Re: Concat and rank in QlikView

Concat and rank

Thu, 12 Jan 2017 07:06:17 GMT

I have next problem

If there are gaps (in words) in the measurement , button works incorrect.

I don't see "product 6 " in filter , but it must be here

='('& Concat(DISTINCT {<Product = {"=Rank(Sum(volumn),4)<=4"}>} Product, ' | ') &')'

Anonymous — Thu, 12 Jan 2017 07:10:57 GMT

Hi,

why don't you get rid of the space in the Product field? You can do that with the trim function while loading the product.

trim(Product)

Or do you really wish to present two different products named Product6 and Product 6?

MK_QSL — Thu, 12 Jan 2017 07:11:40 GMT

Try this

='("'& Concat(DISTINCT {<Product = {"=Rank(Sum(volumn),4)<=4"}>} Product, '"|"') &'")'