topic Variable in Set Analysis in App Development

Variable in Set Analysis

Anonymous — Wed, 17 Jan 2018 11:58:05 GMT

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

Re: Variable in Set Analysis

shraddha_g — Wed, 17 Jan 2018 12:01:35 GMT

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

Re: Variable in Set Analysis

Anonymous — Wed, 17 Jan 2018 12:05:08 GMT

after lots of trial and error ive found this works;

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

Re: Variable in Set Analysis

ijcornish — Wed, 17 Jan 2018 23:49:33 GMT

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

Set Analysis Wizard for QlikView | qlikblog.at