Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
gopikrishnach
Creator
Creator

I have 20 Dimensions and 10 Expression in Straight Table. Due to this facing Performance issue. How to resolve the Issue.

I have 20 Dimensions and 10 Expression in Straight Table. Due to this facing Performance issue. How to resolve the Issue.

12 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

Of course there are various possibilities from changing the datamodel to review your used dimensions and expressions (there shouldn't be calculated dimensions, aggr-functions or nested if-loops) but the best way would be to reduce the number of dimensions and expressions. 20 + 10 = 30 columns is far more as it would be sensible.

- Marcus

gopikrishnach
Creator
Creator
Author

Dear Marcus Sommer,

Thank you for quick response.

There is any possible to do performance tuning in UI, without reducing the number of Dimensions and Expressions.

Regards,

Gopikrishna CH

rupamjyotidas
Specialist
Specialist

Marcus is right, you can't do much of performance tuning when you have so many dimension and expressions

- Probably use less complex equations- set analysis perhaps

- Force the User to select some filters before they can view the Table.

- Divide the table into two or three table , 5 and 5 equations maybe

viveknair1234
Contributor III
Contributor III

Gopi,

You can always use the conditional enabling of dimension and expressions. Its a new feature in Qlikview 11.

By this feature all the columns in the pivot table can be shown as filters and if user selects a particular column then only that column will be visible in the pivot table , so by this option  you need not show all the 30 columns all the time.

Let user selects whichever column he/she wants

gopikrishnach
Creator
Creator
Author

Dear Vivek Nair,

if we use the conditional Enabling option, again it will effect on performance.

Can we create AD HOC report in this scenario?

Regards,

Gopikrishna CH.

viveknair1234
Contributor III
Contributor III

I think I was not clear before.Adhoc reporting in Qlikview is done similar way.Please take a look at the below URl explaining the same.

Adhoc reporting in Qlikview

julian_rodriguez

Hello Gopi,

May be you need to use the QlikView Document Analyzer.

It helps to verify wich fields or expressions can be improved.

Document Analyzer 1.14

Regards

Julian

varshavig12
Specialist
Specialist

Pick metrics

_davidlo
Contributor
Contributor

Hi

Do you have the original file that you can upload and fudge out?

Would be great to see how we can help you with performance tuning.

Looking forward to it

David