Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ronaldwang
Creator III
Creator III

Qlinksense combo chart with Barchart using current year data but line chart using PCP (Prior year)

I want to build a combo chart in qliksense, where the x-axis is using the calendar month. and the y-axis is displayed as corresponding period sales figure, then i want to have a line chart built on Z-axis where showing prior year same month sales figure. any idea how to construct this? many thanks

1 Solution

Accepted Solutions
Vegar
MVP
MVP

Use  month (Jan, Feb, Mar,...) as your dimension.

Bar expression

=sum({< Year={$(=max(Year))}>}Sales)

Line expression

=sum({< Year={$(=max(Year)-1)}>}Sales)

View solution in original post

1 Reply
Vegar
MVP
MVP

Use  month (Jan, Feb, Mar,...) as your dimension.

Bar expression

=sum({< Year={$(=max(Year))}>}Sales)

Line expression

=sum({< Year={$(=max(Year)-1)}>}Sales)