Is there a way to add Date Picker Calendar object in Qlik Sense?

[#1]

Hello,

I need to implement Date from and To filters so that the data can be filtered for Date Range. Is there any way to accomplish this task?

Thanks,

Greeshma

[OmarBenSalem]

Hi Mike,

I want to work with 2 periods in Qlik Sense but I can't figure out a way to do it;

here's what I've done with QlikView:

I have 4 variables for my 2 periods (vDateFrom1, vDateTo1, vDateFrom2, vDateFrom2)

example of the expression:

Sum({<[Calendar date]={'>=$(=Date($(vDateFrom1)))<=$(=Date($(vDateTo1)))'}>}Montant_Vente)

Now, I want to do the same thing in QlikSense; How can I ?

I've tried to use 2 extensions I've found,

DateRangePicker and input variables:

with the input variables, I found out that it only can be text or number format !

With the Date Range Picker here's what I did:

I've chosen periode 1: last 7 days / periode 2 : last 30 days

the result is right, but what's appearing in the periods is so wrong (01/04/2016- 04/04/2016 !!

Is there another way to handle this??

[Michael_Tarallo]

Hi Omar - let me see if swr‌ can assist,

Mike

[OmarBenSalem]

Hi Stephan, I want to use 2 periods in QlikSense like I used to do with qlikview.

here's what I've done with QlikView:

I have 4 variables for my 2 periods (vDateFrom1, vDateTo1, vDateFrom2, vDateFrom2)

example of the expression:

Sum({<[Calendar date]={'>=$(=Date($(vDateFrom1)))<=$(=Date($(vDateTo1)))'}>}Montant_Vente)

To do so, I think that this qWidget extension can help me with that; but I don't have access to download it.

Can you help with that please? thanks.

[#5]

GitHub - NOD507/SenseDateRangePicker: A date range picker extension for qliksense

This is a link the the GitHub for SenseDataRangePicker - implemented into an application before, it works rather well for picking a range without coding it directly in... which is a little less intuitive for an end user.

[OmarBenSalem]

I've tried to use 2 extensions I've found,

DateRangePicker and input variables:

with the input variables, I found out that it only can be text or number format !

I've tried using 2 date range picker extensions:

the dimension of the periode 1 data range picker extension: calendar date : the date of my master calendar

the dimension of the periode 2 data range picker extension: Date_Ticket: the date of my fact table

Sum periode 1: Sum({<[Date_Ticket]=>}Montant_Vente)

Sum periode 2: Sum({<[Calendar date]=>}Montant_Vente)

the result is accurate since I've chosen the last 7 days for periode 1 and last 30 days for periode 2 BUT, when you take a look at the dates appearing in the 2 range calendars, you'll see that  it appears that I've selected from 01/04/2016 to 04/04/2016 for both periods !!

I'm really confused ! Plus, I couldn't use any other calendar extension ! It always shows me the error message or appears as a blank when I drag and drop it ! the page remains blank !

[OmarBenSalem]

Still no answer Mike?

[#8]

Dear Ann

would you mind granting me access as well,please?

best regards

Christian

[scotly-victor]

Hi, swr‌  Can you please add me?

[OmarBenSalem]

I'm already a partner but have no access to the qWidget. Can you please add me? Thanks

[Ann-Louise-Andersson]

Hi , done, you have now access to the "Limited Public Beta of qWidget", just search for qWidget in the search box.