Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

marommishan
New Contributor

Compare Months to each other on Qlik Sense

Hi All

I need to make a comparison of months by day using a line chart. The user should be able to click on the yearmonth field to pick the months that they want to compare. (each year-month will be a different line)

The x-axis will contain day numbers i.e., 1 to 31.

The y-axis will contain sales (cumulative daily so on day 1 it will show amount of sales made on day 1 of each month selected, on day 2 it will show the sales for day 1 + sales for day 2 for each month selected, etc)

Thank you in advance for your advice.

3 Replies
Digvijay_Singh
Honored Contributor III

Re: Compare Months to each other on Qlik Sense

It would be great if you can share the sample app, hope you have used master calendar in your script to create day/month fields etc.

marommishan
New Contributor

Re: Compare Months to each other on Qlik Sense

Thanks for a quick response.

I do have a master calendar:

[autoCalendar]:

  DECLARE FIELD DEFINITION Tagged ('$date')

FIELDS

  Dual(Year($1), YearStart($1)) AS [Year] Tagged ('$axis', '$year'),

  Dual('Q'&Num(Ceil(Num(Month($1))/3)),Num(Ceil(NUM(Month($1))/3),00)) AS [Quarter] Tagged ('$quarter'),

  Dual(Year($1)&'-Q'&Num(Ceil(Num(Month($1))/3)),QuarterStart($1)) AS [YearQuarter] Tagged ('$axis', '$yearquarter'),

  Month($1) AS [Month] Tagged ('$month'),

  Dual(Year($1)&'-'&Month($1), monthstart($1)) AS [YearMonth] Tagged ('$axis', '$yearmonth'),

  Dual('W'&Num(Week($1),00), Num(Week($1),00)) AS [Week] Tagged ('$weeknumber'),

  Date(Floor($1)) AS [Date] Tagged ('$date');

DERIVE FIELDS FROM FIELDS [Date], [pas.Date],[Loan Date], postingdate, loandate USING [autoCalendar] ;

Screenshot (2).png

My current attempts which are not working:

//= sum({< [Date.autoCalendar.Date]= {">=$(=MonthStart(Today()))<= $(=MonthEnd(Today()))"}>} [Unique Subs])

//Sum([Unique Subs])

//Sum({$<[Date.autoCalendar.Month] = {='Month(today())'}>}[Unique Subs])

Unfortunately I cannot share the rest of the app for legal reasons. Would still really appreciate the help

marommishan
New Contributor

Re: Compare Months to each other on Qlik Sense

Community Browser