topic Re: Date conversion affects the CPU utilization in QlikView

Date conversion affects the CPU utilization

lawrance — Fri, 16 Jun 2017 20:04:45 GMT

Hi all,

The below mentioned code affects the CPU utilization and it reaches 80.

Could you please someone help me to resolve this problem.

We have three different date field

Date(date#(Field name, 'YYYY-MM-DD hh:mm:ss),' MM/DD/YYYY-MM-DD hh:mm:ss') as Field_01

Date(date#(Field name, 'YYYY-MM-DD hh:mm:ss),' MM/DD/YYYY-MM-DD hh:mm:ss') as Field_02

Date(date#(Field name, 'YYYY-MM-DD hh:mm:ss),' MM/DD/YYYY-MM-DD hh:mm:ss') as Field_03

Thanks,

Lawrance A

Anil_Babu_Samineni — Sat, 17 Jun 2017 04:13:18 GMT

How you identify the CPU utilization? Can you explain little more

pra_kale — Sat, 17 Jun 2017 05:31:56 GMT

Hi,

Please check the join condition..if joins are not proper between Two tables then CPU utilisation may increase.