Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use month (Jan, Feb, Mar,...) as your dimension.
Bar expression
=sum({< Year={$(=max(Year))}>}Sales)
Line expression
=sum({< Year={$(=max(Year)-1)}>}Sales)
Use month (Jan, Feb, Mar,...) as your dimension.
Bar expression
=sum({< Year={$(=max(Year))}>}Sales)
Line expression
=sum({< Year={$(=max(Year)-1)}>}Sales)