Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

after lots of trial and error ive found this works;

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

View solution in original post

3 Replies
shraddha_g
Partner - Master III
Partner - Master III

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

Anonymous
Not applicable
Author

after lots of trial and error ive found this works;

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

ijcornish
Contributor II
Contributor II

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

Set Analysis Wizard for QlikView | qlikblog.at