Bar chart Year per dimension

jose_vargas — Sat, 16 Nov 2024 03:43:13 GMT

Hi Community.

I have a boar with the next information.

Grapich Bar Chart with 2 dimension (Month and Year), I have 2 Expression, the first expression is "Daily HV" it have to be a Bar and in my example its OK. the second expression is "Daily % Mix" and I need to show in line for each year, in my example I selected 2 years (2017, 2018) and I need to sho 2 line, one line for 2017 and another line for 2018. Its that possible???

Now show one line

Something like this

Best regards.

José

Re: Bar chart Year per dimension

jonathandienst — Tue, 30 Apr 2019 06:04:15 GMT

You may get better results with a combo chart with 4 expressions (rather than two expressions and year in the dimension) and only Month as the dimension. Select the year in the expressions with a set filter, a pattern like this:

Sum({<Year = {2017}>} Value)
Sum({<Year = {2018}>} Value)

Dynamically:

Sum({<Year = {$(=Max(Year)-1)}>} Value)
Sum({<Year = {$(=Max(Year))}>} Value)

topic Re: Bar chart Year per dimension in QlikView

Bar chart Year per dimension

Re: Bar chart Year per dimension