topic Re: Latest reporting month in App Development

Latest reporting month

tomelmslie — Sat, 16 Nov 2024 21:30:21 GMT

Hi,

I am trying to create a field which will allow me to see values in the latest reporting month from my data set.

Is there a standard expression for this? 'ReportingMonth' is my field for reporting months, so I tried to create a dimension 'Max(ReportingMonth)' , but it didn't work. Any ideas?

Thanks, Tom

Re: Latest reporting month

pradosh_thakur — Wed, 30 Jan 2019 11:07:41 GMT

You should not create a dimension as max(ReportingMonth) but use something similar to beloe

sum({ReportingMonth={"$(=max({1}ReportingMonth))"}>}Sales)

Re: Latest reporting month

emrekaya — Wed, 30 Jan 2019 12:33:54 GMT

You should first convert your date to numerical form. Num(ReportingMonth) and then you can use max(num(ReportingMonth)). If you want, you can convert that data to date again.

Please let us know.

Re: Latest reporting month

tomelmslie — Wed, 30 Jan 2019 13:13:09 GMT

Unfortunately both options result in an 'invalid dimension'. If I create this as a measure however, it gives me the right result in a table. Could I solve my problem using a measure rather than a dimension?

Re: Latest reporting month

emrekaya — Wed, 30 Jan 2019 13:39:34 GMT

I am not sure if I understand the problem here. I am new to qliksense and it is probably better not to give an exact answer to your question. But I have some applications which I used dates as a dimension.

Re: Latest reporting month

pradosh_thakur — Wed, 30 Jan 2019 13:43:36 GMT

Tom, The expression i gave you is supposed to be a measure. Either use it in a kpi or as you said use it in a table.

Happy learning !!