#10 Creating a gauge Pie Chart in Qlik Sense
The Gauge or Gauge Pie Chart, what is the most beautiful ?
Be honest, the Gauge chart is a bit ugly (sorry qlik guys), And you can’t do much in the settings to embellish. So I decided to use the unloved Pie Chart to do it.
ValueList(), Pick(Match()) and some conditional coloring 🧙
Ready to use it ?
❓ How To ❓
Since a Pie Chart need one dimension use :
=ValueList('Spent','Available')
And as a measure :
Pick(
Match(ValueList('Spent','Available'),'Spent','Available'),
Sum(Expense),Sum(Available)
)
