Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Attachted formula.
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
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
Hi Stefan,
Please try with the Subfield() Function.
Many thanks Peter, it works.
Regards
Stefan