Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
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