Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Napster
Contributor
Contributor

Bar chart with mixed dimension

Hi All,

I have a table which contain YEAR, MONTH & SALES data. I have created a bar chart where i haves used YEAR as dimension and Sum of SALES as measure expression.

My requirement is that when user has selected any year value, have to show sum of each month value for that selected year  and rest of unselected year value will show as it is.

 

Attaching my output result, may it will help to understand my requirement.

 

Any help really appreciate.

 

Thanks

3 Replies
dplr-rn
Partner - Master III
Partner - Master III

You can use drill down group to show month values when year is selected. but the second part of your requirement (rest of unselected year show as is) is not possible IMHO
sergio0592
Specialist III
Specialist III

Hi,

You can achieve this with:

-Create a Dim "Data island table"

Dim:
LOAD * INLINE [
Dim
1
2];

 

-In your bar chart

as dimension

pick(Dim,Month,'Rest')

 

as expression

pick(Dim,sum(Sales),Sum({1-$} Sales))

 

Take a look to the attached qvw file. Is it what you're trying to achieve?

Napster
Contributor
Contributor
Author

This is what i am not look for.
Have attached my required output screenshot in my main thread. May this will help you to understand the requirement.

Thanks