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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
coleturegroup
Contributor III
Contributor III

Crosstable needed? as headings shown below(Labels) for horizontal Gauge chart

Hey team, I want to make this gauge chart show something like this:

coleturegroup_0-1728492087266.png

You notice I'm having an issue with the labels showing over the correct color in the horizontal gauge.

my load script looks something like this:

DataScores:
LOAD
AutoNumberHash128(AppID) as AppKey,
AppName,

Round(Rand()*(10-1)+1) as QualityScore  //Create a different QualityScore for each App for testing purposes.
FROM [Some.qvd](qvd)
;

ScoreLimits:
// Data Quality Score: 0 --> 1, 2 --> 4, 5 --> 8, 9 --> 10
left join
LOAD * INLINE [
GoodLimits, CautionLimits, WarningLimits, CriticalLimits
0 , 2, 5, 9
];

The expression in the Gauge KPI Measure is:       only(QualityScore)

It was my first thought that a crosstable might do it only haven't been able to get it to work.

Any ideas are appreciated

 

 

Labels (2)
0 Replies