To Display the current month in the month field.

[Ramu_i]

Hi All,

I have Month Field in that data is 01,02,03 ...12 like that,  And I have two filters year and month.

Year filter having 2020 2021 2022 like feature data is there. Another filter Month in that having 01,02,03,...12.

Now I want to display current month sales values, like in the filter pan set default values like if year it will display 2021 and month it will display 09 values. I am using Vizlib filter, 

I tryed Maxstring(Month) here display 12 but current month is sept so here displaying 09.

Thanks 

advance

Regards, Ram

[v_jaideep]

Try this

vCurYear= year(today())

vCurMonth= month(today())

if you want month as number  num(month(today()))

[Ramu_i]

Hi V_jaideep,

I tryed this one  num(Month(today())) here displaying sep.

But in vizlib filter in default selection it is not working .

Vizlib filter set defaut values. But not working 

if(Month(Today())='Jan' ,
Match(Month_Code,'01'),
...
if(Month(Today())='Sep' ,
Match(Month_Code,'09')))

Thanks 

Regards,

Ram

[v_jaideep]

Ram,

In my application, I have month name and if I use =month(today()) as default selection in vizlib filter it is working. I hope you are trying to have default selection under 'interactivity ' tab.

[Ramu_i]

Hi V_jaideep,

I tryed but not working.