Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
dlesny
Contributor II
Contributor II

Dimensions in text boxes

Hello

Currently I am using Gauge Chart the Digital Numbers style on which I am setting the Dimension:

=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.

How can I transfer this to Text Object? How do I force the =BC='BC1' on the Text Object?

"If" is not enough and generally this is not on, but I want this Text Object to  look only at BC Score at BC1 level. 

 

Labels (3)
1 Solution

Accepted Solutions
AxNoxy
Contributor III
Contributor III

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?

Avg({<[BC] = {'BC1'}>} BC Score)

 

Regards!

View solution in original post

2 Replies
AxNoxy
Contributor III
Contributor III

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?

Avg({<[BC] = {'BC1'}>} BC Score)

 

Regards!

View solution in original post

dlesny
Contributor II
Contributor II
Author

Perfect! Thank you very much, exactly what I was looking for.