Linear gauge chart in straight table

yoganantha321 — Wed, 25 Nov 2020 16:16:04 GMT

I have a data source as given below,

with
Previous month as (=Sum({<Temp={"<=$(=Num(Month(Today())))"}>} Value)) one expression,

future month as (=Sum({<Temp={">$(=Num(Month(Today())))"}>} Value))one expression and

YTD as (=Budget-Sum({<Temp={"<=$(=Num(Month(Today())))"}>} Value)-Sum({<Temp={">$(=Num(Month(Today())))"}>} Value)) another expression

I need to show in straight table with linear gauge chart.

I am getting the output as attached image lineargaugechart.png

But my expected linear gauge chart should be given in lineargaugechart_expected.png

anyone can help me!

Regards,

Yoganantha Prakash G P

topic Linear gauge chart in straight table in QlikView