Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Problem with set analysys when text variable contain space or special symbol

I can't figure out how can I overcome this issue.

I have a variable (Top1) which determines the name of 1 top selling brand: =only({<Brand= {"=rank(sum(Sales), Brand) =1"}>} Brand )

then this value is passed to textbox to get the sales for this top brand: =sum({$<Brand={$(Top1)}>}Sales),

Formula works fine if Brand doesn't have spaces or special characters. Please see the screenshot for the results:

error loading image

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Problem with set analysys when text variable contain space or special symbol

Hello and welcome to the Forums,

I think it's because text in set analysis have to be quoted:

=sum({$<Brand={'$(Top1)'}>}Sales)


Hope that helps

2 Replies
Highlighted
MVP
MVP

Problem with set analysys when text variable contain space or special symbol

Hello and welcome to the Forums,

I think it's because text in set analysis have to be quoted:

=sum({$<Brand={'$(Top1)'}>}Sales)


Hope that helps

Not applicable

Problem with set analysys when text variable contain space or special symbol

Many thanks, Miguel. It worked.

Community Browser