topic Re: =Max(Month) is not working in QlikView

=Max(Month) is not working

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

In the below attached app I have loaded Month Field. In the filter pane I am able to see Month. But when i have tried to take

=Max(Month) then I am not able to get Dec on Text object.

In the set analysis also Its not working

Sum({<Month={"$(=Max(Month))"},[Media Type]={'PAID MEDIA'}>}Visits)

Please help me on this

Thanks in advance.

kenphamvn — Tue, 06 Feb 2018 10:17:47 GMT

your Month field is text data type, not Date type

Please convert to Date type before using

Regards

An Pham

big_dreams — Tue, 06 Feb 2018 10:21:44 GMT

try maxString()

Regards

stabben23 — Tue, 06 Feb 2018 10:22:27 GMT

Hi,

I'll think Maxstring maybe helps

Sum({<Month={"$(=Maxstring(Month))"},[Media Type]={'PAID MEDIA'}>}Visits)

bhavvibudagam — Tue, 06 Feb 2018 10:28:23 GMT

Hi ,

Max string is working.

I have used below one in the back end it is also working

Date( Date# ( "Month",'MMM'),'MMM') as Month,

Thanks