Which kind of expressions are used? Simple sum/count(FIELD) should be quite fast but by using (nested) if-loops, aggr() or interrecord-functions in large tables it could slow-down an application quite heavily.
I didn't mention a moving of the calculation to the script - although some pre-calculation with flagging or categorising of the data may be helpful to reduce the complexitity of the expressions and to speed them up - I was just asking to the used expressions. Some examples and screenshots of the objects will be helpful.
Dear Hasan, I have a similar server configuration, 48 cores and 512 GB of RAM.
For my experience in this case the problem is not the "brute power" of the server but the data model, I would try to reduce the levels of the related tables.
I've seen more than 1 levels cause performance impacts. If possible try moving table fields: "distributionHyearchy, distributors, gandola, gadgethierachy in the table of the top level and check the response of the dashboard. The use of the set analisys in any case slows down the output.
It's not really surprising that these calculation is slow because it counts SKU from the products over the probably quite granular key of the fact table. The virtual table which qlik needs to create to perform the calculation will be rather large and on top of it it's further aggregated (avg) to the fact and the distribution bridge table. Here you could find some background of what is happening to perform a calculation: The Calculation Engine.
There may here and there a few measures with which you could improve this and that a bit but I think you will need to change your datamodel to get a significantly more performaning dashboard.