Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have developed a chart in which the name of all the QlikView_apps we have figures,
including the "last" directory - so it reads like
>> 03_Application\[name] <<
=> Now I would like to sort that alphabetically - but that should regard only the
[name] part.
The "sort" tab of the dialog has a checkbox "formula" and I can easily separate that
using >> SUBFIELD([Name], '\', 2) << and then select "ascending" from that dropdown
menu - but for some reason that does not yet seem to work.
Can anyone help me there?
Thanks a lot!
Best regards,
DataNibbler
Hi,
maybe like this?:
hope this helps
regards
Marco