topic Re: Count Distinct and Percentages in script vs expressions on Layout in QlikView

Count Distinct and Percentages in script vs expressions on Layout

Mon, 07 Apr 2014 00:30:45 GMT

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,

Re: Count Distinct and Percentages in script vs expressions on Layout

chiru_thota — Mon, 07 Apr 2014 01:26:41 GMT

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.

Re: Count Distinct and Percentages in script vs expressions on Layout

Mon, 07 Apr 2014 03:43:57 GMT

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

Thanks,

Re: Re: Count Distinct and Percentages in script vs expressions on Layout

chiru_thota — Mon, 07 Apr 2014 03:47:04 GMT

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

I hope it will help

Re: Count Distinct and Percentages in script vs expressions on Layout

Mon, 07 Apr 2014 03:48:54 GMT

Thank you so much.

Re: Count Distinct and Percentages in script vs expressions on Layout

Mon, 07 Apr 2014 04:14:13 GMT

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

Thank you once again.