https://community.qlik.com/t5/QlikView/Dimensions-in-text-boxes/m-p/1557089#M599359 <P>Perfect! Thank you very much, exactly what I was looking for.</P> Fri, 15 Mar 2019 10:46:04 GMT dlesny 2019-03-15T10:46:04Z https://community.qlik.com/t5/QlikView/Dimensions-in-text-boxes/m-p/1556676#M599357 <P>Hello</P><P>Currently I am using Gauge Chart the Digital Numbers style on which I am setting the Dimension:</P><P>=BC='BC1' and then using the expression: =(if(BC='BC1',Avg(BC Score)))*100, which gives me the results I want but people do not like the greyed out area on the charts for the bits not on so I need to change it to Text Object.</P><P>How can I transfer this to Text Object? How do I force the =BC='BC1' on the Text Object?</P><P>"If" is not enough and generally this is not on, but I want this Text Object to &nbsp;look only at BC Score at BC1 level.&nbsp;</P><P><FONT size="1">&nbsp;</FONT></P> Sat, 16 Nov 2024 04:10:03 GMT https://community.qlik.com/t5/QlikView/Dimensions-in-text-boxes/m-p/1556676#M599357 dlesny 2024-11-16T04:10:03Z https://community.qlik.com/t5/QlikView/Dimensions-in-text-boxes/m-p/1556742#M599358 <P>I guees i dont get correctly what are you planing to do, but with Set Analaysis on the text object would be enough? Something like this?</P><P>Avg({&lt;[BC] = {'BC1'}&gt;} BC Score)</P><P>&nbsp;</P><P>Regards!</P> Thu, 14 Mar 2019 17:42:47 GMT https://community.qlik.com/t5/QlikView/Dimensions-in-text-boxes/m-p/1556742#M599358 AxNoxy 2019-03-14T17:42:47Z https://community.qlik.com/t5/QlikView/Dimensions-in-text-boxes/m-p/1557089#M599359 <P>Perfect! Thank you very much, exactly what I was looking for.</P> Fri, 15 Mar 2019 10:46:04 GMT https://community.qlik.com/t5/QlikView/Dimensions-in-text-boxes/m-p/1557089#M599359 dlesny 2019-03-15T10:46:04Z