topic Re: Scripting expression in QlikView

Scripting expression

Zaga_69 — Sat, 16 Nov 2024 03:34:56 GMT

Hi all,

I created a island-table to create an scaling factor (i.e. Million, Thousand, Full). When using this field in my Set Analysis, it does not work properly. when the end-user select the scaling factor, for example Million, the formula, the highlighted one in yellow, just calculates the number correctly for the period selected and not for the other ones. Any idea?

Thanks

Edi

Re: Scripting expression

Lisa_P — Tue, 14 May 2019 22:56:32 GMT

It could be because of the Period={"<=$(=max(Period))"} - the max period is 4

Re: Scripting expression

Vegar — Wed, 15 May 2019 04:57:26 GMT

What happens if you exclude the ScalingNumber form the expression? Does it calculate for all rows?

Your output seems strange, but using a dollar expanded ScalingNumber should remove all issues with it. Try replacing ScalingNumber with $(=only(ScalingNumber)) .

Re: Scripting expression

Zaga_69 — Thu, 16 May 2019 07:08:37 GMT

Many thanks Vegar. It works now!