Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Zeta
Contributor III
Contributor III

Variable heading

Hi all,

in a pie chart, I offer two alternative measures. Depending on which measure is selected, the heading should adapt.

If [measure 1] is selected, then ..., else ...

Does anyone have a solution for me?

Labels (1)
1 Solution

Accepted Solutions
justISO
Specialist
Specialist

Hi, few weeks ago I tried to investigate similar possibility, but my findings was, that it seems you can't distinguish which alternative measure is selected in graphs. So you can't make adaptive label. But you can know what filters are selected, so best what I managed to do is to load additional table with my waned measure names, like:

LOAD * INLINE [
MeasureID, MeasureName

'1',  '1. measure1name'
'2', '2. measure2name'

... ];

Put that 'MeasureName' as filter. Made a measure which calculates different thing depending on what MeasureName is selected (linked to MeasurId):

if(MeasureID = '1', Sum( yourformula1),
if(MeasureID = '2', Sum(  yourformula2)...

And added expression to graphs title field:

 if(GetSelectedCount(MeasureName)=1, MeasureName, '---')

So when you filter one measure, your graph shows one graph and change graph name/heading accordingly.

View solution in original post

1 Reply
justISO
Specialist
Specialist

Hi, few weeks ago I tried to investigate similar possibility, but my findings was, that it seems you can't distinguish which alternative measure is selected in graphs. So you can't make adaptive label. But you can know what filters are selected, so best what I managed to do is to load additional table with my waned measure names, like:

LOAD * INLINE [
MeasureID, MeasureName

'1',  '1. measure1name'
'2', '2. measure2name'

... ];

Put that 'MeasureName' as filter. Made a measure which calculates different thing depending on what MeasureName is selected (linked to MeasurId):

if(MeasureID = '1', Sum( yourformula1),
if(MeasureID = '2', Sum(  yourformula2)...

And added expression to graphs title field:

 if(GetSelectedCount(MeasureName)=1, MeasureName, '---')

So when you filter one measure, your graph shows one graph and change graph name/heading accordingly.