Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
rajtechnocraft
Contributor III
Contributor III

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

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

2 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
rajtechnocraft
Contributor III
Contributor III
Author

thanks...