Latest reporting month

[tomelmslie]

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

[pradosh_thakur]

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

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

[emrekaya]

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.

[tomelmslie]

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?

[emrekaya]

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.

[pradosh_thakur]

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 !!