How to show current month and date data by default in qliksense

[jayati_shrivast]

Hi All,

I have a date ,month and year filter in my dashboard, by default without applying any filter the charts show the total data till date. 

I need to show the current month data by default without applying filter. How can I implement this, pls help me out.

[bhargav_bhat]

Hi Jayati,

1)Convert your month field into 'MMM YYYY' and in text format in script .

2)Use simplefieldselect extension and in selections  default option write 

Text(Date(today(1),'MMM YYYY'))

Regards,

Bhargav

[Dolly123]

not works

[JonathanKelly]

Hi,

The way I locked for current month;  I made 2 variables one for monthstart(today()) and one for monthend(today()). You can put that in as set analysis or as an if statement.

count(if([Datefield]>='$(vMonthstart)' and [Datefield]<='$(vMonthend)', [field])

[vinieme12]

As below, the conditions go as follows

IF No selections have been made in Year/Month/Date field

Then show current month data

Else show whatever is selected

=  if(GetSelectedCount(date)=0 and GetSelectedCount(month)=0 and GetSelectedCount(year)=0

,sum({<date={">=$(=Monthstart(Max(date)))<=$(=Date(Max(date)))"}>}Sales)

,sum(Sales) )