Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

joshpinfoldold
New Contributor III

Variable in Set Analysis

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])

Tags (2)
1 Solution

Accepted Solutions
joshpinfoldold
New Contributor III

Re: Variable in Set Analysis

after lots of trial and error ive found this works;

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

3 Replies
shraddha_g
Honored Contributor III

Re: Variable in Set Analysis

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

joshpinfoldold
New Contributor III

Re: Variable in Set Analysis

after lots of trial and error ive found this works;

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

ijcornish
New Contributor II

Re: Variable in Set Analysis

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

Set Analysis Wizard for QlikView | qlikblog.at

Community Browser