Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
vCurYear= year(today())
vCurMonth= month(today())
if you want month as number num(month(today()))
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
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.
Hi V_jaideep,
I tryed but not working.