Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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
Creator

Bar chart Year per dimension

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

bi1.jpg

 

Something like this

bi2.jpg

Best regards.

José

Labels (2)
1 Reply
Highlighted

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)

 

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein