Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be something like this, if you can share sample, we would know how dates are being entered/formatted-
Date={">=$(vStartDate)<=$(vEndDate)"}
Please try this. Let me know
sum({$<Date = {'<={1/31/2017} >= {1/1/2017'}>} Values)
Thanks.
Hi Ishtdeep ,
this one is not working for me .
Thanks,
Can you pls let me know , that how I can define start and end date in qliksense?
Thanks,
Hi Experts,
Can anyone help in this date range value in set analysis?
Thanks,
Pooja
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.
Hi Rama,
Thanks for your reply . Here my problem is with using this range in set analysis . How I can use that.
Thanks,
Hii,
Try this below.
Sum({<Date={"$(= '>=' & '1/1/2017' & '<=' & '1/31/2017')"}>}Values)
Thanks
Mustaq
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,