topic Bar chart with mixed dimension in QlikView

Bar chart with mixed dimension

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

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

Re: Bar chart with mixed dimension

dplr-rn — Tue, 14 May 2019 18:59:30 GMT

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

Re: Bar chart with mixed dimension

sergio0592 — Tue, 14 May 2019 20:18:21 GMT

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?

Re: Bar chart with mixed dimension

Napster — Wed, 15 May 2019 04:16:01 GMT

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