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

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

Thu, 09 Sep 2010 05:38:06 GMT

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:

Miguel_Angel_Baeyens — Thu, 09 Sep 2010 06:45:53 GMT

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

Thu, 09 Sep 2010 07:09:24 GMT

Many thanks, Miguel. It worked.