Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

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

Bar expression

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

Line expression

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

1 Reply
Highlighted
Partner
Partner

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

Bar expression

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

Line expression

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post