Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Concat and rank

Hi

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, ' | ') &')'

Clip2net_170112100339.png



Tags (2)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Concat and rank

Try this

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

View solution in original post

2 Replies
Highlighted
Contributor III
Contributor III

Re: Concat and rank

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?

Highlighted
MVP
MVP

Re: Concat and rank

Try this

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

View solution in original post