Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

suganthi
New Contributor

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

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.

3 Replies
devarasu07
Honored Contributor II

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

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

qlik_aparnav
Contributor II

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

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
Valued Contributor

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

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

Community Browser