Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI all,
We have dashboard on Retail sales on different products with lot of expressions at front end level.How to increase performance of Dashboard by means of reducing expressions and alternative solutions.
Regards,
avinash
Hi,
1.Take all the expressions in front end and Try to implement them in the script level in backend.
2.If more than 1 fact table is there then , Try to merge them to 1 using joins so that all the dimension tables are directly associated to fact table.
3.Try to avoid most of the conditional fucntions like IF , PICK & MATCH etc..
Thanks,
Vikram
Hi,
1.Take all the expressions in front end and Try to implement them in the script level in backend.
2.If more than 1 fact table is there then , Try to merge them to 1 using joins so that all the dimension tables are directly associated to fact table.
3.Try to avoid most of the conditional fucntions like IF , PICK & MATCH etc..
Thanks,
Vikram
Hi Avinash
Running a search on application performance optimisation in Qlik Community will return many results that will help you on that.
Results from both discussions and white papers/blog posts.
Thanks
Agis Kalogiannis
Senior Technical Trainer, UK&I
chk dis too.