topic Re: Best Practice in QlikView

Best Practice

Anonymous — Wed, 08 Jul 2015 04:17:58 GMT

I have three different categories.

Under each category I need to create 3 charts.

Can I know which is the efficient approach?

1. Creating 3 charts for each of the three categories. i.e 3*3=9 charts

2. Creating 3 charts alone and giving the expressions using conditional statement.

eg. if(Category=1,a/b,if(Category=2,c/d,if(Category=3,e/f)))

In case 2 the total number of charts will be 3 for all the categories.

Please let me know if i am not clear or if further information is required.

Thanks!

Re: Best Practice

MK_QSL — Wed, 08 Jul 2015 08:11:29 GMT

Use Trellis Charts !

Re: Best Practice

alexandros17 — Wed, 08 Jul 2015 08:20:47 GMT

The trellis solution as suggested from Manish Kachhia is a good solution unfortunately trellis hasn't a beautiful layout.

I should use your second solution but if possible I will compute the condition in the script so that the object in front end will have good performance

Re: Best Practice

Anonymous — Wed, 08 Jul 2015 08:23:32 GMT

I would use case 2. it's less Charts and therefor easier to maintain

manishs proposal is good choice if the Charts are that identical as you mentioned in your descrpition

Re: Best Practice

Anonymous — Wed, 08 Jul 2015 11:29:04 GMT

Thanks for the help Alessandro Saccone.

I wont be able to compute the condition in the script because the condition is based on current selection.

So second solution is the best way?

Re: Best Practice

Anonymous — Wed, 08 Jul 2015 11:29:45 GMT

Thanks for the help Rudolf Linder.

Re: Best Practice

Anonymous — Wed, 08 Jul 2015 11:30:16 GMT

Thanks for the suggestion Manish Kachhia.

Re: Best Practice

alexandros17 — Wed, 08 Jul 2015 11:36:14 GMT

I think it is the better

Re: Best Practice

Anonymous — Wed, 08 Jul 2015 12:47:58 GMT

Thanks for the suggestion Allessandro Saccone.