Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

stefan_fischer
New Contributor II

Execute excel formula in QlikView

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

5 Replies
stefan_fischer
New Contributor II

Re: Execute excel formula in QlikView

Attachted formula.

Re: Execute excel formula in QlikView

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

Re: Re: Execute excel formula in QlikView

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

Not applicable

Re: Execute excel formula in QlikView

Hi Stefan,

 

  Please try with the Subfield() Function.

stefan_fischer
New Contributor II

Re: Execute excel formula in QlikView

Many thanks Peter, it works.

Regards

Stefan

Community Browser