topic stacked and combo chart in QlikView

stacked and combo chart

manoj217 — Wed, 25 Nov 2020 16:16:04 GMT

i want graph like this but the years in line chart is not changing dynamically so i have created manual but its not sufficient i want to change it as dynamically please suggest and i have category as dimension and in expressions are shown in below image i make selections on 2014 and 2015 compare the sales and show the difference in line chartte

Re: stacked and combo chart

Anil_Babu_Samineni — Thu, 12 Oct 2017 11:43:03 GMT

Can you change your Line expression like below

Sum(Sales) - Above(Sum(Sales))

Re: stacked and combo chart

sunny_talwar — Thu, 12 Oct 2017 11:43:36 GMT

Would you be able to share a sample app to see what you have?

Re: stacked and combo chart

manoj217 — Thu, 12 Oct 2017 12:15:54 GMT

load * inline [Sales, Category, Year

100,furniture,2014

220,furniture,2015

330,furniture,2016

33,furniture,2017

100,powder,2014

220,powder,2015

330,powder,2016

33,powder,2017];

this data is enough and dimension is category and expression is shown in above image

Re: stacked and combo chart

sunny_talwar — Thu, 12 Oct 2017 12:35:54 GMT

Is there a maximum number of years you will show? Like 4 years maximum at a time?

Re: stacked and combo chart

manoj217 — Thu, 12 Oct 2017 16:34:15 GMT

its example data

Re: stacked and combo chart

sunny_talwar — Thu, 12 Oct 2017 16:38:16 GMT

I know

Re: stacked and combo chart

andrei_delta — Mon, 16 Oct 2017 07:12:26 GMT

Hello,

Maybe this will help you:

sum({<Year={"$(=max(Year))"}>}Sales) -sum({< Year-={"$(=max(Year))"}> * <Year=P(Year)>}Sales)

it takes the max year from your selection in the first expression and for the other makes the sum for all years in your selection excluding the max year (which is calculated in the first expression) and t's dynamical

Hope it helps,

Andrei

Re: stacked and combo chart

MarcoWedel — Tue, 17 Oct 2017 19:46:37 GMT

Hi,

maybe the answers in your other thread regarding this question are helpful?

stacked chart

Please also review your open threads and close those who received correct answers:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco