topic Re: Max Month order amount in QlikView

Max Month order amount

sspawar88 — Fri, 28 Aug 2015 06:33:25 GMT

Hi community,

Why following Expression is not showing result..is it any mistake in it?

sum({$<Month1={$(=max(Month1))}>}[Order Amount])

Re: Max Month order amount

crusader_ — Fri, 28 Aug 2015 06:47:19 GMT

Hi,

Check format of Month1.

Use simple listbox or textbox. In set analysis they must be the same.

I believe that Month1 is a text in your case.

Regards,

Andrei

Re: Max Month order amount

sspawar88 — Fri, 28 Aug 2015 06:50:38 GMT

Month1 is field for Months.

Re: Max Month order amount

crusader_ — Fri, 28 Aug 2015 06:53:45 GMT

Obviously, yes

Show me, please, the script code how do you create this field.

Regards,

Andrei

Re: Max Month order amount

sspawar88 — Fri, 28 Aug 2015 06:57:31 GMT

Year("Reported Date") as Year,

Month("Reported Date") as Month1,

Re: Max Month order amount

kavita25 — Fri, 28 Aug 2015 06:57:51 GMT

Try this

=SUM({< Month1=, Month1={'$(=Maxstring(Month1))'}>}[Order Amount])

Regards,

Kavita

Re: Max Month order amount

sspawar88 — Fri, 28 Aug 2015 07:02:48 GMT

Miracle Miracle

what is Maxstring....

Fantastic

Re: Max Month order amount

crusader_ — Fri, 28 Aug 2015 07:03:49 GMT

Please add

, num(Month(Date)) as numMonth

in your script and use it for Set Analysis.

Regards,

Andrei

Re: Max Month order amount

kavita25 — Fri, 28 Aug 2015 07:08:06 GMT

Maxstring is used for String...

max is used for numeric values..

Re: Max Month order amount

sspawar88 — Fri, 28 Aug 2015 07:10:21 GMT

My answer is in 14.2588887 can you show me how to use num() to restict it on 14.25

Re: Max Month order amount

kavita25 — Fri, 28 Aug 2015 07:15:40 GMT

Try this:

num((SUM({< Month1=, Month1={'$(=Maxstring(Month1))'}>}[Order Amount])),'#.##')

Re: Max Month order amount

sspawar88 — Fri, 28 Aug 2015 07:24:52 GMT

Thank you very much kavita

Re: Max Month order amount

kavita25 — Fri, 28 Aug 2015 07:28:12 GMT

Ur welcome