Performance: QlikSense Chart Dimension Optimization:

[Purushothaman]

Hello Experts,

How to optimize the calculated dimension for Chart?

=if(Category <> 'NA', Category)

Thank you!

[TcnCunha_M]

You create this in the Load script 😁

Best way is have this one the load script the same if.

Keep in mind: If it's a if can be a field on the load

[vincent_ardiet_]

If you don't have access to the loading script, you can try like this (no idea if this is performant enough but without IF this should be better):
=Aggr({<Category-={NA}>} Only(Category),Category)

[TcnCunha_M]

Performance will be bad, because it's a Aggr with Only i think is similar performance as if 

[Or · Accepted solution]

Either create a field in script as previously suggested, or use Category as the dimension, and a set analysis of {<Category-={NA} >} in the measures.

[anat · Accepted solution]

Or else use dimensions as Category

Define measure like sum({<Category-={NA}>} sales) 

[sidhiq91]

@Purushothaman  I think the best approach would be to try in the load script itself.

Load *

From Table

where category<>'NA';