topic Re: heavy performance in QlikView

heavy performance

Anonymous — Thu, 12 Oct 2017 13:38:01 GMT

hi qlikers

i am execute below set analysis on dashboard expression and it cost delay of performance

any suggestion for boost the preformance

//count({$<DownPaymentDate2 = {">=01/01/2013"} , TempDate = {<$(">=01/01/2013")>}>}

//if(date(Date#(DownPaymentDate2, 'DD/MM/YY'),'MM/YYYY')= date(Date#(TempDate, 'DD/MM/YY'),'MM/YYYY'),DownPaymentDate2))

Re: heavy performance

sunny_talwar — Thu, 12 Oct 2017 13:41:00 GMT

Can you clearly write your expressions.... problems

1) Why is the first two lines commented out?

2) TempDate set analysis is not right... I wonder if this expression is even working?

TempDate = {<$(">=01/01/2013")>}>}

3) Why do you need Date and Date# functions in your if statement? Are they not read as dates by QlikView? If they are not, then how why the set analysis work? and If they are, then why do you need Date and Date# functions

Re: heavy performance

swuehl — Thu, 12 Oct 2017 13:44:24 GMT

Besides what Sunny already mentioned, how are your two date fields related to each other in your model?

Are they located in the same table or in different tables?

Re: heavy performance

Anonymous — Thu, 12 Oct 2017 14:17:04 GMT

well , it is working fine but it takes long time to generate ,

each field in different table and TempDate is in calendar master

i used Date# function because i only want to month and year to get accurate count during the selected month period

if i assume make count by creation date will not get me correct count because creation could be early month of year and downpayment date happens current month !

Re: heavy performance

juliedecoene — Thu, 12 Oct 2017 14:58:52 GMT

Hi,

The Date() function will only format the output, but won't remove the day from the number. I would rather use:

MonthStart(DownPaymentDate2)= MonthStart(TempDate)

However this will probably not solve your performance issue, but that is hard to help without knowing how your model looks like and what you are trying to achieve here.