Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

singhpooja
Contributor III

Custom date range selection in qliksense

Hi Experts,

Currently I have requirement of analyzing my data for entered data range like following.

Given date range is ( for ex) <=1/31/2017>=1/1/2017


How I can use above range in set analysis for getting sum of my field for this range?


Thanks,

Pooja

12 Replies
Digvijay_Singh
Honored Contributor III

Re: Custom date range selection in qliksense

May be something like this, if you can share sample, we would know how dates are being entered/formatted-

Date={">=$(vStartDate)<=$(vEndDate)"}

isingh30
Contributor III

Re: Custom date range selection in qliksense

Please try this. Let me know

sum({$<Date = {'<={1/31/2017} >= {1/1/2017'}>} Values)

Thanks.

singhpooja
Contributor III

Re: Custom date range selection in qliksense

Hi Ishtdeep ,

this one is not working for me .

Thanks,

singhpooja
Contributor III

Re: Custom date range selection in qliksense

Can you pls let me know , that how I can define start and end date in qliksense?

Thanks,

singhpooja
Contributor III

Re: Custom date range selection in qliksense

Hi Experts,

Can anyone help in this date range value in set analysis?

Thanks,

Pooja

ramasaisaksoft
Valued Contributor III

Re: Custom date range selection in qliksense

You can then use the search input box and type in the date text like this:

>=1/6/2015<=1/10/2015

This will give you all dates from 1/6 to 1/10

Let me know if this is an acceptable alternative.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.


singhpooja
Contributor III

Re: Custom date range selection in qliksense

Hi Rama,

Thanks for your reply . Here my problem is with using this range in set analysis . How I can use that.

Thanks,

MohammedMustaq
Contributor

Re: Custom date range selection in qliksense

Hii,

Try this below.

Sum({<Date={"$(= '>=' & '1/1/2017' & '<=' & '1/31/2017')"}>}Values)

Thanks

Mustaq

singhpooja
Contributor III

Re: Custom date range selection in qliksense

Hi Mustaq,

Thanks for your reply but this value is changing by selection from fields. Can U pls let me know that how my selection should not affect this value , this should be same for any kind of field selection.

Thanks,

Community Browser