topic Quarter field inline wizard vs Ceil function to calculate Quarter from Date field in QlikView

Quarter field inline wizard vs Ceil function to calculate Quarter from Date field

rajtechnocraft — Wed, 06 Jul 2011 10:02:42 GMT

Dear Members,

Just wanted to know

Performance of Quarter Inline wizard Vs Ceil function for quarter('Q' & ceil(month(date)/3) as Quarter

Which method is fater to load the data.

I am doing performance optimisation of my application and want to reduce the reduce the refresh time.

Regards

Raj

Quarter field inline wizard vs Ceil function to calculate Quarter from Date field

kaushiknsolanki — Wed, 06 Jul 2011 10:10:58 GMT

Hi,

As far as performance is concern, your inline table is a best option, but the problem is if you have many no. of years, you have to manually include them in a inline table.

Where as Ceil() does some calculation, thus it may take few seconds to calculate value, but its the best option when you have many no. of years.

The over all performance will not effect much in both case.

Regards,

Kaushik Solanki

Quarter field inline wizard vs Ceil function to calculate Quarter from Date field

rajtechnocraft — Wed, 06 Jul 2011 10:34:43 GMT

thanks...