How to include 'ALL' as a section in the period selector box

[abc_18]

Hi  all,

Requirement is to, Include option ‘All’ in the period selector. which allows the user to select all data, rather than limiting the data to a certain period.

I have created a data island table for this and the script for data island table is like below:-

v_periods:

LOAD

    period_type as %period_type,

    period_type_description as %period_type_description

FROM [$(vQVDLib)v_periods.qvd](qvd)

where period_type='fin_ytd' or

period_type='fin_month' or etc;

left join v_periods:

LOAD

    %period_type,

    %period_set_analysis

FROM [$(vExternalDataLib)Frea_Periods.csv]

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq)

Based on flag calculation like (if(fmonth_offset = 0,1,0) as [Current Month-flag],) it's picking the values for different selector.

In my dashboard filter box is like:-

select period

current month

year

financial year

How can I include 'ALL' as another filter in this period selection box?? please suggest

Thanks

[Anonymous]

Is this for the use in a KPI object?

Otherwise you could just deselect all values and this would result in being shown all the data.