Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
mahamedfaijan
Creator II
Creator II

Script help

Below script is taking very long time to reload about 1 hour.

Please help to modify it to reduce reload time

 

 

Fact:

LOAD

if(wildmatch(Attribute, '*DATE*') or wildmatch(Attribute, '*date*') or wildmatch(Attribute, '*Date*'),
date(floor([Attribute Value]),'MM/DD/YYYY'),
if(wildmatch(Attribute, '*prem*') or wildmatch(Attribute, '*PREM*') or wildmatch(Attribute, '*Prem*'),
text(num([Attribute Value],'$#,##0.00')),
text([Attribute Value]))) as [Attribute Value],
if(len(num([Attribute Value],'###,###,###,###,###'))>0,[Attribute],null()) as [Attribute Num],

1 Reply
marcus_sommer
MVP & Luminary
MVP & Luminary

Your snippet of the load could be optimized but I doubt that this alone will have a very big effect on the run-times unless it breaks an optimized load. Nevertheless try:

alt(pick(wildmatch(upper(Attribute), '*DATE*','*PREM*'),
    date(floor([Attribute Value]),'MM/DD/YYYY'), num([Attribute Value],'$#,##0.00')),
    text([Attribute Value])) as [Attribute Value],
num([Attribute Value],'###,###,###,###,###') as [Attribute Num],

- Marcus