How to filter result by current month?

[#1]

Dear All,

I got a question:

I am doing a KPI report. The data is stored with the month column like 2016-01, 2016-02. ...

Now I would like to display current month's data such as now only 2016-12 be selected. How can I define this filter?

Appreciated.

Trent Gu

[Anonymous]

Hi ,

As per my understanding , U need to filter the data for current month when u opened dashboard  ?

if yes

create one action   Document propertirs>Triggers>on  open document> add action> select in field> max(datefield)

[Anonymous]

Hi,

You need to create a action.

IF you want to select current month when u opened dashboard then :-

Lets assume your Field name is MonthCol

Create one action

Document propertirs>Triggers>Onopen<Has Action(s)> add action> Select in field> Put Column Nmae in Field (MonthCol)

and Put Condition =Date(Today(),'YYYY-MM')  in Search Field.

THanks

[shraddha_g]

you can do it by 2 ways.

1. Using Month filter in Set analysis in all expressions.

2. Default selection to Month as 2016 -12 by using extension Qlik Branch

[lakshmikandh]

Declare a variable and use the variable in your KPI calculations, assign the variable in the Load script to default to the desired values.

[#6]

I tested this extension, looks cool but the initial selection not working.

[#7]

Thanks but I am so junior and even don't know where to edit it.

[shraddha_g]

can you share your sample?

[#9]

HI, The extension worked for me now. It is very helpful.

It don't work before because I set the "per session" but I don't re-logon.

Now it is working.

Thanks very much.

[renuka_sasikumar]

Hello,

Even I have the same requirement max year & max month to be selected when the dashboard is opened.

Is it possible without using extension.

Regards,

Renuka S