Skip to main content

New to Qlik Sense

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

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
jay_shahi90
Contributor II
Contributor II

Set analysis on qtr-yr

Hello,

I have data from 2015 Q3 to 2017 Q2

I am trying to show a line chart that would show the sum of the years data with 2 lines containing the following values:
(Q3-2015---Q2-2016) and (Q3-2016----Q2-2017)

I know you have to use set analysis, but i am having trouble with the syntax.

Please let me know.

Thanks,

Jay

2 Replies
Digvijay_Singh

Use measures like this - format your dates as per your data.

Measure-

Sum({<Date={">=$(=Date(MakeDate(2015,6,01),'MM-DD-YYYY'))<=$(=Date(MakeDate(2016,6,30),'MM-DD-YYYY"))}>}Sales)

zebhashmi
Specialist
Specialist

Sum({$<your_date-Field = {">=start_date<=End_date"}>}Sales)