topic Re: still facing issue-Need urgent help in QlikView

still facing issue-Need urgent help

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

i used below logic it worked fine till yesterday because it took current quarter and next three quarters that is 2018Q4,2019Q1,2019Q2,2019Q3

but today i moved to current quarter as 2019Q1... but below logic not changed dynamically in production still it is showing 2018Q4,2019Q1,2019Q2,2019Q3 only need urgent help its production issue..

='=Rank( if(Quarter>=Year(Today())&''Q''&Ceil(Month(Today())/3), -(Left(Quarter,4)*10+Right(Quarter,1))))<5'

Future Data

On Open trigger

Re: still facing issue-Need urgent help

soniasweety — Thu, 01 Nov 2018 05:19:38 GMT

My result on open trigger now ... 2019Q1,2019Q2,2019Q3,2019Q4 because my curent quarter 2019Q1

Re: still facing issue-Need urgent help

tresB — Thu, 01 Nov 2018 05:26:40 GMT

Do you define your quarter in custom logic in script? Today is 1st Nov, 2018 and that should be in normal calendar 2018Q4. If you have a different logic for quarter, your expression would require some tweaking.

Re: still facing issue-Need urgent help

soniasweety — Thu, 01 Nov 2018 05:29:10 GMT

No logic,,, we are getting the Quarter column from Database directly.. no calendar used in script.

below is the criteria.

Q1 - Nov, Dec, Jan

Q2 - Feb, Mar, Apr

Q3 - May, Jun, Jul

Q4 - Aug, Sep, Oct

Re: still facing issue-Need urgent help

soniasweety — Thu, 01 Nov 2018 06:04:35 GMT

Hi tresesco any work around ?

Re: still facing issue-Need urgent help

tresB — Thu, 01 Nov 2018 06:42:49 GMT

Do you have date, year and month fields as well in your actual data model? If so, try to share an app with sample data with all such fields.

Re: still facing issue-Need urgent help

andrey_krylov — Thu, 01 Nov 2018 06:53:47 GMT

Hi Sony. As I understood your year starts today and just added 2 months. Not sure but try this

='=Rank( if(Quarter>=Year(AddMonths(Today(), 2))&''Q''&Ceil(Month(AddMonths(Today(), 2))/3), -(Left(Quarter,4)*10+Right(Quarter,1))))<5'

Re: still facing issue-Need urgent help

Frank_Hartmann — Thu, 01 Nov 2018 10:01:55 GMT

I thought we solved this probleme already in some of your previous threads!

='=Rank(if(Quarter>=if(Month(Today(1))>=11,Year(Now())+1&''Q'' & Ceil((Mod((Month(Today(1))+2),12))/3),
if(Month(Today(1))=10,Year(Now())&''Q'' & Ceil((Mod((Month(Today(1))+12),12))/3),Year(Now())&''Q'' & Ceil((Mod((Month(Today(1))+2),12))/3))) and
Quarter<=if(num(month(Monthstart(Today(1))+12))=1,Year(Now())&''Q'' & Ceil((Mod((Month(Today(1))+9),12))/3),Year(Now())+1&''Q'' & Ceil((Mod((Month(Today(1))+11),12))/3))
,Quarter))<5'

see attached for solution

hope this helps