Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
singhpooja
Creator III
Creator 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

13 Replies
Digvijay_Singh

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

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

isingh30
Specialist
Specialist

Please try this. Let me know

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

Thanks.

singhpooja
Creator III
Creator III
Author

Hi Ishtdeep ,

this one is not working for me .

Thanks,

singhpooja
Creator III
Creator III
Author

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

Thanks,

singhpooja
Creator III
Creator III
Author

Hi Experts,

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

Thanks,

Pooja

ramasaisaksoft

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
Creator III
Creator III
Author

Hi Rama,

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

Thanks,

MohammedMustaq
Partner - Creator
Partner - Creator

Hii,

Try this below.

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

Thanks

Mustaq

singhpooja
Creator III
Creator III
Author

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,