topic Re: Need Help on Selecting Month as default selection in QlikView

Need Help on Selecting Month as default selection

Thu, 18 Jun 2015 08:36:32 GMT

Hi Team,

Hope all re doing good....!

I need help on selecting the month which has recent data as a default selection while opening the application.

For Ex: i have year filed 2015 and in 2015 i have data till may only.

so when i opened my application by default it has to show may.

my month filed has month names not numbers.

i tried Max(month) in document triggers but its not working.

Please help on this.....

Thanks in advance...

Nani.

Re: Need Help on Selecting Month as default selection

daniel_kusiak — Thu, 18 Jun 2015 08:39:44 GMT

In script add ceil(month(date_field)) as month_no and after reload put max(month_no) in document triggers.

Re: Need Help on Selecting Month as default selection

Thu, 18 Jun 2015 08:42:28 GMT

Thanks for your reply...

is there any way we can do it without modifing in script?

Re: Need Help on Selecting Month as default selection

jagan — Thu, 18 Jun 2015 08:47:47 GMT

Hi Nani,

Try like this

Settings -> Document Properties -> Triggers -> Document Event Triggers-> On Open -> Add Actions-> Add -> Selection-> Select In Field ->

Field - Year

Search String - =Max(Year)

Again Add -> Selection-> Select In Field ->

Field - Month

Search String - =Max(Month)

Finally give OK -> OK -> OK

Hope this helps you.

Regards,

Jagan.

Re: Need Help on Selecting Month as default selection

Thu, 18 Jun 2015 08:57:02 GMT

Hi Jagan,

Thanks for responding.

I did the same as u mentioned above, Year is getting selected but not month.

when I tried Max(Month) in a test object its displaying "5" as result instead of May.

my month field contains month names not month numbers. so it is not getting selected.

Thanks,

Nani

Re: Need Help on Selecting Month as default selection

daniel_kusiak — Thu, 18 Jun 2015 08:57:31 GMT

For me it dosen't work otherwise.

Re: Need Help on Selecting Month as default selection

daniel_kusiak — Thu, 18 Jun 2015 09:02:16 GMT

Try date(max(ceil(date_field)),'MMM') in document triggers.

See the attached file.

Re: Need Help on Selecting Month as default selection

jagan — Thu, 18 Jun 2015 09:10:05 GMT

Hi,

Try like this

=Text(Max(Month))

Regarsd,

Jagan.

Re: Need Help on Selecting Month as default selection

Thu, 18 Jun 2015 09:11:18 GMT

By default it is showing Jan as Month.

But I have to display May.

Re: Need Help on Selecting Month as default selection

Thu, 18 Jun 2015 09:13:46 GMT

Hi Jagan,

Tried, But no luck result is same 5.

Re: Need Help on Selecting Month as default selection

daniel_kusiak — Thu, 18 Jun 2015 09:13:58 GMT

Please see the attached file once more.

Re: Need Help on Selecting Month as default selection

Chanty4u — Thu, 18 Jun 2015 09:15:19 GMT

PFA

when ever you want to disply recent selected

you must chk dat option and save it and close

and reopen ur application....you will get last selected values

hope this helps you

Thank you

Suresh

Re: Need Help on Selecting Month as default selection

jagan — Thu, 18 Jun 2015 09:16:23 GMT

Hi,

Can you attach sample file, it would be easier to provide the solution.

Or try this

=Text(Date(Max(Month), 'MMM'))

Regards,

Jagan.

Re: Need Help on Selecting Month as default selection

Thu, 18 Jun 2015 09:18:35 GMT

Hi Suresh,

That is the case in my requirement.

I have to default month to max month which has the data in our application(not last selected month) in month filter.

in 2015 we have data upto may.

so in my scenario I have to default it to may.

Re: Need Help on Selecting Month as default selection

Thu, 18 Jun 2015 09:19:02 GMT

Try

MaxString(Month)

Re: Need Help on Selecting Month as default selection

Thu, 18 Jun 2015 09:23:12 GMT

On Field Value Trigger try char(max(month))

Re: Need Help on Selecting Month as default selection

Thu, 18 Jun 2015 09:23:31 GMT

Hi Ashish,

Thanks for your solution.

It is working fine...

Regards,

Nani

Re: Need Help on Selecting Month as default selection

Chanty4u — Thu, 18 Jun 2015 09:23:40 GMT

try as

sum({<Row={"=[MaxDate] >= max(total [Months]) <="})

Thank you

Suresh

Re: Need Help on Selecting Month as default selection

jagan — Thu, 18 Jun 2015 09:29:00 GMT

Hi,

This is not the correct solution

If you have data upto december this will return September not December. Verify it. If you attach sample file it would be easier to understand your data.

MaxString(Month)

Regards,

Jagan.

Re: Need Help on Selecting Month as default selection

Thu, 18 Jun 2015 09:46:42 GMT

Hi Jagan,

I tested with 2014 data where I have data till December and it is working and returned Dec.

Thanks,

Nani