gauge chart- expression doubt-to show latest month data as default

[hosasahana]

hi all,

REquest your help on below issue.

I am trying to create a gauge chart with some calculation, but I want the default value to be shown for latest yearmonth column which I have. I tried with variable ,max(yearmonth) directly also but nothing helps. 

Can you help resolve this issue?

I have tried below but doesn't help. 

max(yearmonth) =Feb-21

avg({<process='A',yearmonth=$(latest month) >},value)--- >$(latest month)=max(yearmonth)

avg({<process='A',yearmonth=max(yearmonth) >},value)

Also latest yearmonth should be as default, and on diff yearmonth selection it should change.

[MayilVahanan · Accepted solution]

HI @hosasahana 

Try like below

avg({<process={'A'},yearmonth={'$(=max(yearmonth))'} >}value)

[hosasahana]

hi Mayil,

thankyou so much, it works. 🙂

just one more help. If I have to make my yearmonth filter also always to be selected for latest month by default, what should I do? 

regards,

Sahana

[MayilVahanan]

Hi @hosasahana 

May be, you can try with bookmark or action (if you are using latest qliksense) or some extension.