Can a calculated master measure be used in set analysis

[She1]

Good Day,

Can a calculated master measure be used in set analysis.

For eg: count({<recruitment_stage={'ACTIVE'},QdaProfileRank={'VeryHigh'}>}company_name)

The field in blue is the calculated measure. But the measure doesn't seem to be making any impact on the result set.

Should the entire expression making the field be used in the field space.

Another Question,please let me know if a field with the below  expression should be a dimension or a measure. Logically it should be a dimension because I am assigning string values to the field based on comparison between measures. But dimension gets invalid as soon as I create it.

//computes very high scores
if( Sum(
{<recruitment_stage = {'ACTIVE'}>}
revenue_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
employee_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
data_analytics_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
existing_partnerships_ana_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
existing_partnerships_auto_score)
+
Other_Partnership_DA_Score > Floor($(vPlusTwoStDevQda)),'VeryHigh',
/*
or
*/

//computes high scores
if (Sum(
{<recruitment_stage = {'ACTIVE'}>}
revenue_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
employee_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
data_analytics_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
existing_partnerships_ana_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
existing_partnerships_auto_score)
+
Other_Partnership_DA_Score <= Floor($(vPlusTwoStDevQda))

and

Sum(
{<recruitment_stage = {'ACTIVE'}>}
revenue_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
employee_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
data_analytics_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
existing_partnerships_ana_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
existing_partnerships_auto_score)
+
Other_Partnership_DA_Score > ceil($(vPlusOneStDevQda)) ,'High',

//computes medium scores

if (Sum(
{<recruitment_stage = {'ACTIVE'}>}
revenue_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
employee_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
data_analytics_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
existing_partnerships_ana_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
existing_partnerships_auto_score)
+
Other_Partnership_DA_Score <= Ceil($(vPlusOneStDevQda))

and

Sum(
{<recruitment_stage = {'ACTIVE'}>}
revenue_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
employee_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
data_analytics_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
existing_partnerships_ana_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
existing_partnerships_auto_score)
+
Other_Partnership_DA_Score >= ceil($(vAvgQda)) ,'Medium',

//computes the low rank

if (Sum(
{<recruitment_stage = {'ACTIVE'}>}
revenue_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
employee_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
data_analytics_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
existing_partnerships_ana_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
existing_partnerships_auto_score)
+
Other_Partnership_DA_Score <= floor($(vAvgQda))

and

Sum(
{<recruitment_stage = {'ACTIVE'}>}
revenue_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
employee_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
data_analytics_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
existing_partnerships_ana_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
existing_partnerships_auto_score)
+
Other_Partnership_DA_Score >= ceil($(vMinusOneStDevQda)) ,'Low',

//computes very low rank

if (Sum(
{<recruitment_stage = {'ACTIVE'}>}
revenue_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
employee_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
data_analytics_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
existing_partnerships_ana_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
existing_partnerships_auto_score)
+
Other_Partnership_DA_Score < ceil($(vMinusOneStDevQda)) ,'VeryLow'

)))))

Any help will be appreciated.

Thanks!

[edwin · Accepted solution]

i dont think you can use a measure as a field in set analysis, there are ways to get around that though.  if you can explain what exactly the expression is, someone can maybe find a way.

you can use p and e functions or something like this:
https://community.qlik.com/t5/App-Development/Display-maximum-and-minimum-value/m-p/1954261#M78698

[edwin]

for the 2nd question (it took a wile to understand what you were doing from the looong expression) use AGGR for the sums, in tables, you can inject sums in your dimension if you use aggr.

[She1]

Thank you so much for your patience. Your suggestions do help. I am pretty new to all these BI tools so having a hard time putting things together.😊

[edwin]

advise on this part:
Sum(
{<recruitment_stage = {'ACTIVE'}>}
revenue_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
employee_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
data_analytics_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
existing_partnerships_ana_score)
+
Sum(
{<recruitment_stage = {'ACTIVE'}>}
existing_partnerships_auto_score)

if you are constantly aggregating a group of metrics maybe their aggregation means something, you may want to create a new field representing the sum of these fields - that is depending on your DM, so if for the same row, you have these as separate columns, you may want to add a new column which is the sum of these.  so in your expression you just sum that specific column.  the expression will run faster.  that is of course if grouping specific metrics together makes sense