Insight Advisor - what causes disabled fields?

stascher — Wed, 16 Apr 2025 20:40:23 GMT

Hi, I have a couple of questions regarding Insight Advisor.

1) In my app's Logical Model, I have a Measure group with two particular fields in it.

Both fields are configured with the same characteristics: Visibility = visible, Classification = measure, Data Value Lookup = no, Default Aggr = sum. Both fields are populated with integer values.

When I go to the Insight Advisor page I can see both fields displayed in the Fields list on the left.

But when I choose the Calculated measure (KPI) analysis type, one of the fields becomes disabled so that it's not selectable. But the other remains enabled and is selectable.

What would cause this difference in behavior?

2) Also, is there any issue caused by putting fields that are classified as measures into a Dimension group or fields that are classified as dimensions into a Measure group? Since you are allowed to do this, and Qlik actually does it by default sometimes, I would think this does not cause a problem. But if it doesn't matter where you put fields, then why have separate Dimension and Measure group types? Is it simply for organizational purposes?

Thank you for any responses,

Steven

Re: Insight Advisor - what causes disabled fields?

stascher — Tue, 29 Apr 2025 21:15:07 GMT

The answer is that the disabled field contained only null values.

topic Insight Advisor - what causes disabled fields? in App Development

Insight Advisor - what causes disabled fields?

Re: Insight Advisor - what causes disabled fields?