Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
HI @hosasahana
Try like below
avg({<process={'A'},yearmonth={'$(=max(yearmonth))'} >}value)
HI @hosasahana
Try like below
avg({<process={'A'},yearmonth={'$(=max(yearmonth))'} >}value)
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
Hi @hosasahana
May be, you can try with bookmark or action (if you are using latest qliksense) or some extension.