Count Distinct and Percentages in script vs expressions on Layout

[#1]

Hi All,

I would like to know what is the usual practice to implement Count Distinct and percentages. I have few calculations like Sales/count Distinct Orders etc.

At present I have implemented these kind of calculations on the layout in one of the chart list, but now my users asks me to give all the calculations in field list. I would like to know what is the best practice.

Does qlikview roll up properly when we use count distinct in Load script?

Thanks,

Mc

[chiru_thota]

Best way of doing it is adding a new column to table which has numeric value 1 for first occurrence of order.

This way you can avoid distinct count at front end which is resource consuming.

As per as I know always calculate percentages at frontend expressions. That way we can make sure accurate values when you drill up and down by different dimensions values.

[#3]

Thanks Chiranjeevi Thota Can you please send me the document you were referring to in the above screenshot?

Thanks,

MC

[chiru_thota]

Sorry I don't have soft copy of it....I have a PDF with scanned pages.

I hope it will help

[#5]

Thank you so much.

[#6]

Chiranjeevi Thota If you have complete book can you please upload in google drive and share it?

Thank you once again.