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

[ronaldwang]

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

[Vegar · Accepted solution]

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

Bar expression

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

Line expression

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