topic Re: MaxString working on Qlik Sense Desktop and not the Online version in App Development

MaxString working on Qlik Sense Desktop and not the Online version

McCloudPT — Sat, 16 Nov 2024 19:26:26 GMT

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

Re: MaxString working on Qlik Sense Desktop and not the Online version

jonathandienst — Tue, 17 Dec 2019 11:53:14 GMT

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.