topic Re: Set Action for my calculated Date field in QlikView

Set Action for my calculated Date field

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

Hi Experts - Quick clarification..

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

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

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

MonthName((if(YDAY=Aggr( NODISTINCT Max(YDAY),Month_Name, Year_Name),YDAY))))

Now my requirement is ...when i open the Document i need the maximum month to be selected by default.. Since it is a calculated expression, am finding difficult to set an action for this.. Any idea ? how to get this done ?

Re: Set Action for my calculated Date field

techvarun — Tue, 31 Oct 2017 06:07:51 GMT

is it possible to share a sample app?

Thanks

Varun

Re: Set Action for my calculated Date field

tresB — Tue, 31 Oct 2017 06:11:13 GMT

Could you post a sample? I guess if you have a dual month field, you can just use trigger to select the max of that month field and should work.

Moreover, the expression you are using seems to be one not very optimistic. Perhaps a better performant and easy expression would be there.

Re: Set Action for my calculated Date field

Gysbert_Wassenaar — Tue, 31 Oct 2017 06:11:26 GMT

It looks like you could select the maximum value in the YDAY field instead.

If that doesn't give the result you want then I'd try to create a field in the script for the calculated date field instead of trying to use a calculated dimension.

Re: Set Action for my calculated Date field

bharani8 — Tue, 31 Oct 2017 06:44:03 GMT

Hi In the attached qvw file.... i need the below requirements...

1) When i select the month, last date of the month alone should get selected... And that last date will be the value for whole month..

2) When i open the document.. By default the max(YDAY) should be selected..

Re: Set Action for my calculated Date field

bharani8 — Tue, 31 Oct 2017 06:44:42 GMT

Plz refer above reply msg (To Varun's)

Re: Set Action for my calculated Date field

bharani8 — Tue, 31 Oct 2017 06:44:48 GMT

Plz refer above reply msg (To Varun's)

Re: Set Action for my calculated Date field

tresB — Tue, 31 Oct 2017 06:49:18 GMT

Like in attached sample?

Field: YDAY

Search string: =Date(Max(YDAY))

Re: Set Action for my calculated Date field

bharani8 — Tue, 31 Oct 2017 06:52:46 GMT

Hi - In ur qvw file.. I need the Sep to be selected and under sep.. max(YDAY)...

Re: Set Action for my calculated Date field

tresB — Tue, 31 Oct 2017 06:56:21 GMT

Add one more trigger. PFA