Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
ksharpes
Creator
Creator

Reference Section Title in Script

Hello,

Am I able to reference my Section title within the script?

1 Solution

Accepted Solutions
ksharpes
Creator
Creator
Author

So I actually worked out a way to get around this.

Rather than use a Variable in my expression, i have used a StateName() and then created a statename for each of the options needed then assigned the state to the chart.

I am unsure of the impact it will have on the speed of the app as yet, but will report back if any issues arise.

The below is part of the expression I am using for reference:

Sum({1<[BU15]={"$(=Statename())"}>}[Sales Value] )

View solution in original post

2 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

AFAIK no - but you could reference on already loaded tables/data and also use sub-routines and/or variables to avoid redundant stuff.

- Marcus

ksharpes
Creator
Creator
Author

So I actually worked out a way to get around this.

Rather than use a Variable in my expression, i have used a StateName() and then created a statename for each of the options needed then assigned the state to the chart.

I am unsure of the impact it will have on the speed of the app as yet, but will report back if any issues arise.

The below is part of the expression I am using for reference:

Sum({1<[BU15]={"$(=Statename())"}>}[Sales Value] )