topic Re: Getting max field (On calculated field) while opening the Document in QlikView

Getting max field (On calculated field) while opening the Document

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

Hi Experts,

Gm!

I have a calculated Month field and below is my expression..

=if((right(Date(if(YDAY=Aggr( NODISTINCT Max({<CALENDAR_YEAR_MONTH_CD = ,YDAY = ,Month_Name = , Year_Name =>}YDAY),Month_Name, Year_Name),YDAY),'MM/DD/YYYY'),4) &

lEFT(Date(if(YDAY=Aggr( NODISTINCT Max({<CALENDAR_YEAR_MONTH_CD = ,YDAY = ,Month_Name = , Year_Name =>}YDAY),Month_Name, Year_Name),YDAY),'MM/DD/YYYY'),2)) = CALENDAR_YEAR_MONTH_CD,

MonthName((if(YDAY=Aggr( NODISTINCT Max({<CALENDAR_YEAR_MONTH_CD = ,YDAY = ,Month_Name = , Year_Name =>}YDAY),Month_Name, Year_Name),YDAY))))

I see all the Months (No Issues)... Now my requirement is ... While opening the document , i need the max Month in this list box to be selected by default.. How can I?

Re: Getting max field (On calculated field) while opening the Document

luismadriz — Thu, 30 Nov 2017 04:56:39 GMT

Hi,

This is a wild guess

=AGGR(ONLY({<CALENDAR_YEAR_MONTH_CD={"=$(=Max({1} CALENDAR_YEAR_MONTH_CD))"}>} CALENDAR_YEAR_MONTH_CD), CALENDAR_YEAR_MONTH_CD)

Cheers,

Luis

Re: Getting max field (On calculated field) while opening the Document

bharani8 — Thu, 30 Nov 2017 05:02:53 GMT

No... When i apply the expression that i had mentioned .. i see Month's column in a List box... In that List box i want the max month to be selected by Default while opening the document..

Re: Getting max field (On calculated field) while opening the Document

luismadriz — Thu, 30 Nov 2017 05:17:50 GMT

Hi,

Sorry, I misread your issue. I've never done it but found the following for Qlikview

Default Selection in Qlikview

I hope this helps,

Cheers,

Luis

Re: Getting max field (On calculated field) while opening the Document

Anil_Babu_Samineni — Thu, 30 Nov 2017 05:19:54 GMT

What is your Month Field here?

Can you test this for a while =Max(MonthField)

Re: Getting max field (On calculated field) while opening the Document

bharani8 — Thu, 30 Nov 2017 05:24:16 GMT

Hi Anil - I have created the below expression(For Month field) to achieve the Biz logic ... Now i see the Months after the below Expression is applied... Requirement is Now i need the max Month to be selected from this expreesion while opening the document..

=if((right(Date(if(YDAY=Aggr( NODISTINCT Max({<CALENDAR_YEAR_MONTH_CD = ,YDAY = ,Month_Name = , Year_Name =>}YDAY),Month_Name, Year_Name),YDAY),'MM/DD/YYYY'),4) &

lEFT(Date(if(YDAY=Aggr( NODISTINCT Max({<CALENDAR_YEAR_MONTH_CD = ,YDAY = ,Month_Name = , Year_Name =>}YDAY),Month_Name, Year_Name),YDAY),'MM/DD/YYYY'),2)) = CALENDAR_YEAR_MONTH_CD,

MonthName((if(YDAY=Aggr( NODISTINCT Max({<CALENDAR_YEAR_MONTH_CD = ,YDAY = ,Month_Name = , Year_Name =>}YDAY),Month_Name, Year_Name),YDAY))))

Re: Getting max field (On calculated field) while opening the Document

Anonymous — Thu, 30 Nov 2017 05:29:29 GMT

try this way .. add an action on open --> select in field -->Date field --> in the string --> use your your calculation that has been used for calculated dimension.

Re: Getting max field (On calculated field) while opening the Document

bharani8 — Thu, 30 Nov 2017 05:33:45 GMT

Since this is calculated one.. We dont have any specific name for this.. That is the challenge i face now..

Re: Getting max field (On calculated field) while opening the Document

bharani8 — Thu, 30 Nov 2017 05:38:05 GMT

Anil - Is there a way of converting this to variable and calling the max of Variable while opening the document ?

Re: Getting max field (On calculated field) while opening the Document

Anonymous — Thu, 30 Nov 2017 05:44:20 GMT

Yes I agree bharani, the calculated field is based on YDAY which is a date, so I believe that shud be your field to use

I have this =max(if(Date>'08/01/2015' and Date<'04/15/2017',Date)) in on open action its working my original Date has some thousand dates but I took the range I wanted and calculated it .. its working...

Re: Getting max field (On calculated field) while opening the Document

Anil_Babu_Samineni — Thu, 30 Nov 2017 05:49:45 GMT

Try a luck in text object? Is it returning anything? If so, Manipulate with Date Format using..

Max( if((right(Date(if(YDAY=Aggr( NODISTINCT Max({<CALENDAR_YEAR_MONTH_CD = ,YDAY = ,Month_Name = , Year_Name =>}YDAY),Month_Name, Year_Name),YDAY),'MM/DD/YYYY'),4) &

LEFT(Date(if(YDAY=Aggr( NODISTINCT Max({<CALENDAR_YEAR_MONTH_CD = ,YDAY = ,Month_Name = , Year_Name =>}YDAY),Month_Name, Year_Name),YDAY),'MM/DD/YYYY'),2)) = CALENDAR_YEAR_MONTH_CD,

MonthName((if(YDAY=Aggr( NODISTINCT Max({<CALENDAR_YEAR_MONTH_CD = ,YDAY = ,Month_Name = , Year_Name =>}YDAY),Month_Name, Year_Name),YDAY)))))

Re: Getting max field (On calculated field) while opening the Document

bharani8 — Thu, 30 Nov 2017 05:50:42 GMT

Hi John - I tried that..No Luck

Re: Getting max field (On calculated field) while opening the Document

bharani8 — Thu, 30 Nov 2017 05:52:44 GMT

I tried this in text box and i see some value as "43040" in text box

Re: Getting max field (On calculated field) while opening the Document

Anil_Babu_Samineni — Thu, 30 Nov 2017 05:57:43 GMT

And your Month Field format? Can you work using Date format as i already stated like your current format with in textbox?

Re: Getting max field (On calculated field) while opening the Document

bharani8 — Thu, 30 Nov 2017 06:01:07 GMT

Yes i did that... and i see Month name.. Next ?

Re: Getting max field (On calculated field) while opening the Document

Anil_Babu_Samineni — Thu, 30 Nov 2017 06:06:18 GMT

Now try same concept using Trigger for search string like below?

=Date(Max( if((right(Date(if(YDAY=Aggr( NODISTINCT Max({<CALENDAR_YEAR_MONTH_CD = ,YDAY = ,Month_Name = , Year_Name =>}YDAY),Month_Name, Year_Name),YDAY),'MM/DD/YYYY'),4) &

LEFT(Date(if(YDAY=Aggr( NODISTINCT Max({<CALENDAR_YEAR_MONTH_CD = ,YDAY = ,Month_Name = , Year_Name =>}YDAY),Month_Name, Year_Name),YDAY),'MM/DD/YYYY'),2)) = CALENDAR_YEAR_MONTH_CD,

MonthName((if(YDAY=Aggr( NODISTINCT Max({<CALENDAR_YEAR_MONTH_CD = ,YDAY = ,Month_Name = , Year_Name =>}YDAY),Month_Name, Year_Name),YDAY))))),'Your Format Here')

Re: Getting max field (On calculated field) while opening the Document

bharani8 — Thu, 30 Nov 2017 06:09:32 GMT

Yes i see the max date selected and the respective month name..

=Date(Max( if((right(Date(if(YDAY=Aggr( NODISTINCT Max({<CALENDAR_YEAR_MONTH_CD = ,YDAY = ,Month_Name = , Year_Name =>}YDAY),Month_Name, Year_Name),YDAY),'MM/DD/YYYY'),4) &

LEFT(Date(if(YDAY=Aggr( NODISTINCT Max({<CALENDAR_YEAR_MONTH_CD = ,YDAY = ,Month_Name = , Year_Name =>}YDAY),Month_Name, Year_Name),YDAY),'MM/DD/YYYY'),2)) = CALENDAR_YEAR_MONTH_CD,

MonthName((if(YDAY=Aggr( NODISTINCT Max({<CALENDAR_YEAR_MONTH_CD = ,YDAY = ,Month_Name = , Year_Name =>}YDAY),Month_Name, Year_Name),YDAY))))),'MMM-YYYY')

Re: Getting max field (On calculated field) while opening the Document

Anil_Babu_Samineni — Thu, 30 Nov 2017 06:11:46 GMT

Now, Apply same expression using Trigger - OnOpen Event - Select in Field - Your Field name & Search string as same you replied with equal sign

Re: Getting max field (On calculated field) while opening the Document

bharani8 — Thu, 30 Nov 2017 06:11:56 GMT

But i didnt get that Trigger and search String... Where is that and how should i use ?

Re: Getting max field (On calculated field) while opening the Document

bharani8 — Thu, 30 Nov 2017 06:16:39 GMT

I Tried.. No Luck