Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all
I'm currently using MaxString to provide my dashboard of the latest sw version of a specific hardware device with the following code:
MaxString(Aggr(text(maxstring({1<DateDay = {"$(=Max(DateDay))"},Tech={'IPTV'},KPI = {'Check STB Version'}>}[SWVersion])),Tech,DateDay))
The AGGR comes in handy as I collect this version information every hour, and would like to have the latest/top version of the day, reported on the dashboard.
It does work on Qlik Sense Desktop and does not provide any info on the Qlik Sense Online!
What could explain different behaviours on the same solution?!
Best regards
I will hazard a guess that this is due to different default date formats between the environments. You are relying on a default conversion inside your set expression. You might want to make it explicit:
MaxString(Aggr(text(maxstring({1<DateDay = {"$(=Date(Max(DateDay)))"},Tech={'IPTV'},KPI = {'Check STB Version'}>}[SWVersion])),Tech,DateDay))
default, or for specific format:
MaxString(Aggr(text(maxstring({1<DateDay = {"$(=Date(Max(DateDay), 'YYYY/MM/DD'))"},Tech={'IPTV'},KPI = {'Check STB Version'}>}[SWVersion])),Tech,DateDay))
You may need to adapt the date format for the correct one for your environment.