topic Re: Re: Execute excel formula in QlikView in QlikView

Execute excel formula in QlikView

Anonymous — Tue, 14 Jan 2014 07:22:36 GMT

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

Re: Execute excel formula in QlikView

Anonymous — Tue, 14 Jan 2014 07:23:59 GMT

Attachted formula.

Re: Execute excel formula in QlikView

Peter_Cammaert — Tue, 14 Jan 2014 08:24:39 GMT

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

Peter_Cammaert — Tue, 14 Jan 2014 08:41:07 GMT

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

Re: Execute excel formula in QlikView

Tue, 14 Jan 2014 08:47:32 GMT

Hi Stefan,

Please try with the Subfield() Function.

Re: Execute excel formula in QlikView

Anonymous — Tue, 14 Jan 2014 08:48:27 GMT

Many thanks Peter, it works.

Regards

Stefan