Automaticly show latest month by opening Qv app.

[#1]

Hello All,

Currently i am working on a KPI dashboard which should show % of sickness within a company . All this is going fine.

But now the thing is, i would like to show automaticly the % sickness of the latest month of the latest year when opening this Qview dashboard.

Could u tell me how and where i put in this action?

If u need any further information let me know.

Michael

[Miguel_Angel_Baeyens]

Hello Michael,

I think you can do that in the document properties, Triggers, On Open. There you can add a Select on Field action to select

Month(Today())

which always be the current (latest) month.

Regards.

[#3]

Hi sumit,

I hope it may help you. create one varaible and assign with Month(Today()) and Year(Today()),then place that one in your expression. or Directly you can place in expression.

Regards,

Ravi...