topic Re: How to use the max or maxstring function in QlikView

How to use the max or maxstring function

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

Hi,

I have a field called FYQTR that will store data like FY2016-QR4, FY2016-QR3,FY2016-QR2, FY2016-QR1 and so each year. I have created 2 additional fields to store the numbers FY & QTR that will have 2016 and 4 respectively.

So, I have the following expression:

=Count({1<FY={2016}, QTR={">03"} >} AutoID)

Because I want to count the AutoID that appears when the FY is 2016 and QTR is 4.

I want to make this automatically, so I am trying to use the maxstring function but is not working at all.

I have tried:

=Count({1<MaxString(FYQTR)>} AutoID)

But does not work, any idea on how can I have the same functionality but automatically.

Re: How to use the max or maxstring function

Anonymous — Fri, 07 Oct 2016 14:56:26 GMT

may be try with Dual() function

Re: How to use the max or maxstring function

Anil_Babu_Samineni — Fri, 07 Oct 2016 14:59:51 GMT

Perhaps This, This will give count of AutoId Where FY is 2016 and QTR is 4 and then FYQTR the value is maxstring of FYQTR

=Count({1<FY={2016}, FYQTR = {"=$(MaxString(FYQTR))"}, QTR={'04'} >} AutoID)

Re: How to use the max or maxstring function

Anonymous — Fri, 07 Oct 2016 14:59:57 GMT

What would be the correct way to use the Dual() function in my script example?

Re: How to use the max or maxstring function

sunny_talwar — Fri, 07 Oct 2016 15:03:39 GMT

May be try this:

=Count({1<FYQTR = {"$(=MaxString(FYQTR))"}>} AutoID)

Re: How to use the max or maxstring function

sunny_talwar — Fri, 07 Oct 2016 15:04:44 GMT

Anil the equal sign goes inside the dollar sign expansion (and not outside)

=Count({1<FY={2016}, FYQTR = {"=$(MaxString(FYQTR))"}, QTR={'04'} >} AutoID)

Re: How to use the max or maxstring function

Anil_Babu_Samineni — Fri, 07 Oct 2016 15:09:17 GMT

Yes Sunny, I thought this might work. Because i've tried same expression with diff fields using set operator. But it is given Good result. Anyway, Thanks for the solvation. Please correct me if i am wrong

If we created one variable like below

LET V1 = MaxString(FYQTR)

This case, We are not using the = Symbol, right? From this below expression we are not using the = Symbol, Right

=Count({1<FY={2016}, FYQTR = {"=$('$(V1)')"}, QTR={'04'} >} AutoID)

Re: How to use the max or maxstring function

Anonymous — Fri, 07 Oct 2016 15:47:11 GMT

Thank you for the comments, everything worked properly with that.

Re: How to use the max or maxstring function

sunny_talwar — Fri, 07 Oct 2016 15:52:03 GMT

Awesome