Discussion Board for collaboration on QlikView Layout & Visualizations.
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
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.
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.
Please try with the Subfield() Function.
Many thanks Peter, it works.