Execute excel formula in QlikView

[Anonymous]

Hi,

i want to extract a part of an text string in windows title of a chart. The formula works in excel, but in QlikView I don’t know the exact logic function to create the right formula. Please help.

AAA -> AAA

AAA:/:AA - AA

AAA:/:AA:/:A1 -> A1

Regards

Stefan

[Anonymous]

Attachted formula.

[Peter_Cammaert]

The not-very-elegant solution? Use this expression:

=IF (IsNull(site3), IF (IsNull(site2), site1, site2), site3)

You better fix this in your load script. Example coming up.

Peter

[Peter_Cammaert]

Since your hierarchy doesn't change after a reload (and has Always-One-Selected on);, you can use something like this example to lift the top of the TreeView hierarchy.

Good luck,

Peter

[#5]

Hi Stefan,

  Please try with the Subfield() Function.

[Anonymous]

Many thanks Peter, it works.

Regards

Stefan