Default Current Data Month

brf10043 — Thu, 21 Apr 2016 14:15:51 GMT

I am attempting to display a table that contains the latest month in the data.

I have variable vCurrentMonth defined as "$(=MonthName(AddMonths(max(MonthName),0)))" and am using the following expresions in my table. Only({<MonthName = {$(vCurrentMonth)}>}Vulnerability)

At a glance this seems to work fine. The data for the most current data month is displays and when I select a different month, the data is updated with the selected month's data.

However, when you select multiple months, you will always only get the latest month of the selected months.

I would love to have the table default to the latest month in the data and when other / additional months are selected have the table then refresh with all the selected month. I know that using the Max month in the variable is forcing the table to only show the latest month no matter what is selected.

Suggestions?

Re: Default Current Data Month

sunny_talwar — Thu, 21 Apr 2016 16:48:12 GMT

Seems like the same issue?

Default to Latest Month

Please close this thread if it is the same issue (have not read through, but seems the same )

Re: Default Current Data Month

Pulkit_Thukral — Thu, 21 Apr 2016 18:31:02 GMT

Similar to this:

Only({<[Call_Year-Month]={"$(=DATE(FLOOR(MonthStart(Today())),'YYYY-MMM'))"}>}Vulnerability)

topic Re: Default Current Data Month in QlikView

Default Current Data Month

Re: Default Current Data Month

Re: Default Current Data Month