topic Re: Max Bucket in QlikView

Max Bucket

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

Hi Folks,

I've one list box called Yardstick and it contains R3M, R12M,QTR and YTD(PFB for your reference)

My requirement is in text object, only Maximum bucket should display If I select QTR.

So here my desired output should be Apr'18-June'18. I've tried with below expression but no luck.

Aggr(Max(RollingPeriodString),Yardstick)

would someone can suggest how do I achieve this requirement.

Appreciate your effort.

Thanks

Re: Max Bucket

Gysbert_Wassenaar — Fri, 12 Oct 2018 09:23:39 GMT

The max value doesn't work on string values. Perhaps you can turn your RollingPeriodString values into values with both a numeric value and a string display format value using the Dual() function.

Re: Max Bucket

Anonymous — Fri, 12 Oct 2018 11:00:33 GMT

Do you not have the actual date field ? Use that instead. I am assuming you created the string field afterwards.

Date fields are duel, meaning numerical functions such as Max can be used.

Re: Max Bucket

antonybi — Fri, 12 Oct 2018 19:43:44 GMT

Hi Gysbert,

Thanks for the response.

Would you be able to elaborate this in detail.

I've tried with dual but didn't work.

Please suggest if have any other alternatives.

Re: Max Bucket

Gysbert_Wassenaar — Sun, 14 Oct 2018 04:53:09 GMT

See these blog posts:

Data Types in QlikView

Dual & Exists – Useful Functions

If that doesn't help you solve your problem the please post a small qlikview document that illustrates the problem.

Re: Max Bucket

antonybi — Sun, 14 Oct 2018 21:10:00 GMT

Thanks Gysbert for the response.

I've tested with Yardstick-QTR

Yes Almost reached in filter and In text object I have taken Max(RollingPeriodString1) and its displaying 3.

But here my desired output should be Apr'18-Jun'18.

Please find the below sample script along with dual and correct me if I'm anything wrong.

Before:

After changes with dual:

Look forward your quick response.