Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jay_shahi90
New Contributor

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
Honored Contributor III

Re: Set analysis on qtr-yr

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
Valued Contributor

Re: Set analysis on qtr-yr

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

Community Browser