Variable in Set Analysis

[Anonymous]

Hi Guys,

I have a variable which returns a SubSubCategory that has shown the greatest percentage increase from last week. How can i use the results of this (a text string) in a set analysis.

The variable expression is;

FirstSortedValue(distinct

     {<Feedback_Day_Start={"<=$(=date(max(Feedback_Day_Start)-7))>=$(=date(max(Feedback_Day_Start)-13))"}>}

     SubSubCategory, -aggr(

          (count({<Feedback_Day_Start={"<=$(=date(max(Feedback_Day_Start)))>=$(=date(max(Feedback_Day_Start)-6))"}>}[Insight           Sentiment])

          /

          count({<Feedback_Day_Start={"<=$(=date(max(Feedback_Day_Start)-7))>=$(=date(max(Feedback_Day_Start)-13))"}>}[Insight      Sentiment]))-1,

SubSubCategory))

I thought I could use the variable as follows;

count({<SubSubCategory={'=$(vMaxCategory%Change)'}>} [Insight Sentiment])

[shraddha_g]

Try count({<SubSubCategory={'$(=vMaxCategory%Change)'}>} [Insight Sentiment])

[Anonymous · Accepted solution]

after lots of trial and error ive found this works;

count({<SubSubCategory={'$(=$(vMaxCategory%Change))'}>} [Insight Sentiment])

[ijcornish]

For future reference, I find that this site is invaluable for Set Analysis:-

Set Analysis Wizard for QlikView | qlikblog.at