reverse function qliksense

ilanbaruch — Tue, 05 Dec 2017 09:45:42 GMT

hi,

i'm trying to use reverse function in qliksense script but load fails (not supported function).

in the app as a calculated dimension it gives an error expression...

reverse(Field2) as Reverse_Field2 (is that the correct syntax)

any ideas?

Re: reverse function qliksense

felipedl — Tue, 05 Dec 2017 12:36:26 GMT

Hi ilan,

There is no reverse function in qlik string functions.

See the link for the available string functions:

Maybe you used this link as reference:

But sense doesn't use macro as Qlikview.

As an alternative, you'd have to do in in code, something like the below script:

Load * Inline

[

Desc

I like Qlikview!

];

let vString = peek('Desc',0,'x');

let vLen = Len('$(vString)');

let vStringNew = '';

for i = 1 to Len('$(vString)')

vStringPart$(i) = Mid('$(vString)',$(i),1);

next;

let i = Len('$(vString)');

let vStringNew = '$(vStringNew)' & '$(vStringPart$(i))';

trace $(vStringNew) $(i);

i = i -1;

loop while i > 0;

data:

Load

'$(vString)' as Original,

'$(vStringNew)' as Reversed

AutoGenerate(1);

drop table x;

You could use the code i've done and use it as a sub called reverse to do this trick for you.

To achieve the following reversed string and get it to a table: