Is there any Date Filter based on Weekly,Monthly,Quaterly,Yearly in Qlik Sense?

[suganthi]

I am in need of a radio button Filter with options to select weekly,Monthly,Quarterly,Yearly in Qlik Sense.

Weekly-Should filter weekdays (Sun,Mon,Tue,Wed,Thu,Fri,Sat)data.

Monthly-Should filter Month (Jan,Feb,Mar,.....,Nov,Dec) data.

Quarterly-Should filter Quarter wise data.

Yearly-Should filter Year wise data.

So that I can Select either weekly,Monthly,etc in the radio button and my entire charts will get filtered accordingly to the selection made in the radio button.Is there any extension like this for Qlik Sense.or else How Can I achieve this.Please help me with this.

[devarasu07]

Hi,

Qlikview/sense is associative tool, you just need to create master calendar and then add your filters (Year,Month,Week, Date etc) and based on your value selection your chart will change.

u can use below master calendar script and load your fact table (ensure both same name of your date field and qlik is case-sensitive )

Master Calendar Generation Script

[Anonymous]

You can try using filter panes as radio buttons are not available in QS.

Or else you can try using extensions in Qlik Branch

[bwisealiahmad]

Hi,

Have a look at this extension called "Climber Selection Bar". You can chose which Field you want to have so it is a given that you have the fields. The fields you can generate with a Master Calendar Script and then use the extension to get more of a radio button feel to selections.

http://branch.qlik.com/#!/project/5775290349fc1bfca8047ad2