optmization

[satishqlik]

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.

[Chanty4u]

Hi check below thread,

mwoolf  Explained very good , use if instead of pick match 

Re: IF vs Pick Match

[jmvilaplanap]

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