Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
rajtechnocraft
Creator
Creator

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
Creator
Creator
Author

thanks...