Qlik Community

Qlik Sense App Development

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

Not applicable

Calculated Dimension / Show Condition - Performance?

Hello All.

If I have a calculated Dimension who's purpose is to filter a table, and I use an IF statement like the one below, can it have a negative impact on performance? I know in general it's better to use Set Analysis, but I haven't found a way to filter a table dimension using Set Analysis.

IF([FIELD1]='VALUE',[FIELD1])

1 Solution

Accepted Solutions
CarlosAMonroy
Contributor III

Re: Calculated Dimension / Show Condition - Performance?

Hi Josh,

In some cases, calculated dimensions may affect your app performance. I think it depends on the data volume and also the complexity of the data model.

You can use the condition in the set analysis.

E.g.

Dimension: FIELD1

Expression: sum(Sales)

Expression using set analysis: sum({<FIELD1={'VALUE'}>}Sales)

That will show only sales for the specific value defined in the set analysis.

Carlos M

2 Replies
CarlosAMonroy
Contributor III

Re: Calculated Dimension / Show Condition - Performance?

Hi Josh,

In some cases, calculated dimensions may affect your app performance. I think it depends on the data volume and also the complexity of the data model.

You can use the condition in the set analysis.

E.g.

Dimension: FIELD1

Expression: sum(Sales)

Expression using set analysis: sum({<FIELD1={'VALUE'}>}Sales)

That will show only sales for the specific value defined in the set analysis.

Carlos M

Not applicable

Re: Calculated Dimension / Show Condition - Performance?

Thank you for the response Carlos. I knew about this option, but was trying to avoid having an unnecessary aggr field at the end of my table of data. It takes up unnecessary space and seems less than professional. This seems more like a "workaround". Even so, I'm going to mark it your response as the correct answer since it seems like this is the only way to achieve this.