topic Re: optmization in QlikView

optmization

satishqlik — Wed, 25 Nov 2020 16:16:04 GMT

Am applying some optimizing Technics to my existing qlikview application(150MB).

It has only datamodel(one fact table which is surrounded by various dimension tables) and it has no UI.

In the scripting part,It has many If conditions something like

If(DATE_OF_JOIN<>Old_DATE_OF_JOIN,'Old: '&Date(Old_DATE_OF_JOIN)&' New: '&Date(DATE_OF_JOIN), Null()) as DATE_OF_JOIN

Here I can't use combination of Pick and match function

So Is there any option instead of using If condition??

and I have also Where conditions something like

Load from <>.qvd

Where not Exists(Key,Text(Trim(COMPANY_CODE))&'-'&Text(Trim(EMPLOYEE_CODE))&'-'&Text(Trim(SUB_PROCESS_CODE))&'-'&Text(Trim(GISCODE))&'-'&Text(Trim(PRIMARY_REPORT_TO))&'-'&Num(Floor(DATE_OF_JOIN))

&'-'&Text(Trim(GRADE_CODE))&'-'&Text(Trim(SECTION_CODE))&'-'&Text(Trim(OFFICE_CODE)))

and Num(Floor(DATE_OF_JOIN))<>Num(Floor(Today()-1));

Here any alternate solution for QVD optmized load??

Any suggestions would be appreciated.

Re: optmization

Chanty4u — Mon, 31 Jul 2017 10:09:50 GMT

Hi check below thread,

mwoolf Explained very good , use if instead of pick match

Re: IF vs Pick Match

Re: optmization

jmvilaplanap — Mon, 31 Jul 2017 10:12:08 GMT

Hi,

For the second condition, you can create a numeric key before store the QVD file, with hash functions, the comparasion will be faster.

About the first one, I think one solution can be this:

If(DATE_OF_JOIN <> Old_DATE_OF_JOIN, 1, 0) as joinFlag

And later, if joinFlag = 1, in the UI use the formula: Old: ' & Date(Old_DATE_OF_JOIN) & ' New: ' & Date(DATE_OF_JOIN)

With this trick, the table will use less memory.

Regards