Custom date range selection in qliksense

[Anonymous]

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

[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]

Please try this. Let me know

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

Thanks.

[Anonymous]

Hi Ishtdeep ,

this one is not working for me .

Thanks,

[Anonymous]

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

Thanks,

[Anonymous]

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.

[Anonymous]

Hi Rama,

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

Thanks,

[MohammedMustaq]

Hii,

Try this below.

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

Thanks

Mustaq

[Anonymous]

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,