Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Scripting expression

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?

scaling factor issue.JPG

Thanks

Edi

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

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)) .
Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

3 Replies
Highlighted
Employee
Employee

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

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)) .
Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

Highlighted
Creator
Creator

Many thanks Vegar. It works now!