Gauge chart

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

Can any one please help me to do.

I have used this below expression in text object

=if(INTERVAL(

Median({<CDTS_Year=, CDTS_Month=, CDTS_Quarter=,CDTS_Week=, CDTS_Date= {">=$(=Date(YearStart(max(CDTS_Date)),'MM/DD/YYYY')) <=$(=Date(max(CDTS_Date),'MM/DD/YYYY'))"},

CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'},EV_DISPOSITION={'*'}-{'ADVEVNT','CANCELEV','DUPNCAN'},RESPONSETIME_FLAG = {'INCLUDE'},PRIORITY={'2'}>}RESPONSETIME_SEC/86400),'mm:ss')>'09:75','qmem://<bundled>/BuiltIn/arrow_n_r.png',

'qmem://<bundled>/BuiltIn/arrow_s_g.png')

For the above expression my result is '08:58'.My benchmark is 09:75.This time need to get down arrow .Is that format is correct which i have used '09:75'.

Please help me to do this same in gauge chart.how to take the segments its not getting correctly.

I n gauge chart i have taken below one in expression.

Median({<CDTS_Year=, CDTS_Month=, CDTS_Quarter=,CDTS_Week=, CDTS_Date= {">=$(=Date(YearStart(max(CDTS_Date)),'MM/DD/YYYY')) <=$(=Date(max(CDTS_Date),'MM/DD/YYYY'))"},

CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'},EV_DISPOSITION={'*'}-{'ADVEVNT','CANCELEV','DUPNCAN'},RESPONSETIME_FLAG = {'INCLUDE'},PRIORITY={'2'}>}RESPONSETIME_SEC/86400)

In presentation Text in chart have taken

=iNTERVAL(

Median({<CDTS_Year=, CDTS_Month=, CDTS_Quarter=,CDTS_Week=, CDTS_Date= {">=$(=Date(YearStart(max(CDTS_Date)),'MM/DD/YYYY')) <=$(=Date(max(CDTS_Date),'MM/DD/YYYY'))"},

CALL_SOURCE={'ANI/ALI','PHONE','WALK-IN'},EV_DISPOSITION={'*'}-{'ADVEVNT','CANCELEV','DUPNCAN'},RESPONSETIME_FLAG = {'INCLUDE'},PRIORITY={'1'}>}RESPONSETIME_SEC/86400),'mm:ss')

But needle is showing at 0 only.

Thanks,

Re: Gauge chart

agomes1971 — Tue, 30 Aug 2016 15:45:12 GMT

Hi,

post a sample it's easier to analyze.

Thanks

André Gomes

topic Gauge chart in QlikView

Gauge chart

Re: Gauge chart