topic Re: Very slow expression (Hyperlink) in QlikView

Very slow expression (Hyperlink)

francisvandergr — Thu, 02 Oct 2014 13:00:24 GMT

I have a very slow expression. Can is formula below change into set analyses. Because i know it is better to use no if statements in expressions

=if(Table.Name2='Helpdesk' and Verzoek.HelpdeskStatus='Openstaand' and Afdeling.Naam='Software', 'URL'&Verzoek.Hyperlink )

Another solution is to change it in a dimension. But can a link also be a dimension ?

Anonymous — Thu, 02 Oct 2014 13:12:52 GMT

Hi!

I'm not sure if it will work, but you can try this expression:

MaxString({$<Table.Name2={'Helpdesk'},Verzoek.HelpdeskStatus={'Openstaand'},Afdeling.Naam={'Software'}>}'URL'&Verzoek.Hyperlink)

Regards,

Gabriel

Anonymous — Thu, 02 Oct 2014 13:18:05 GMT

build flags in your script (if it is possible) and use the flags

it is easier to cpmpar with a number rather than compar a string

(espiacally if there are huge number of data)

Script

load ..

if (Name2='Helpdesk',1,0) as FlagHelpdesk

...

and in your Expression

if (FlagHelpdesk=1 and ...