topic Re: Different year value in a single bar with different color in QlikView

Different year value in a single bar with different color

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

hello everyone,

i have below chart, which is contain monthly sale

but i want show like below,means in a single bar it will show only jan's 16 and 17 sales(no need to show year in chart) data with two different color how it will be possible?

Thank You.

Re: Different year value in a single bar with different color

Anil_Babu_Samineni — Wed, 22 Nov 2017 08:34:26 GMT

That's not possible. Are you expecting 2016 and 2017 same as in your Image?

Re: Different year value in a single bar with different color

Anonymous — Wed, 22 Nov 2017 08:38:34 GMT

I am expecting like below

Re: Different year value in a single bar with different color

Anil_Babu_Samineni — Wed, 22 Nov 2017 08:41:21 GMT

Looks like achievable.

Create Bar chart and

Dimension is

Month(FieldName)

Expression

Sum({<Year = {'2017'}>} Sales)

Sum({<Year = {'2016'}>} Sales)

And setting should change like in style tab you need to change from Group to Static.

Re: Different year value in a single bar with different color

tresB — Wed, 22 Nov 2017 08:44:35 GMT

Try like:

Dim1: Month

Dim2: Year

Exp: <your exp>

Bar chart->Style tab->Subtype 'Stacked'

Re: Different year value in a single bar with different color

jyothish8807 — Wed, 22 Nov 2017 08:46:35 GMT

Try this:

Use staked chart option.

Br,

Re: Different year value in a single bar with different color

devarasu07 — Wed, 22 Nov 2017 08:50:51 GMT

Hi,

may be this?

Re: Different year value in a single bar with different color

Anonymous — Wed, 22 Nov 2017 08:56:24 GMT

it show like this

Re: Different year value in a single bar with different color

Anonymous — Wed, 22 Nov 2017 08:57:56 GMT

i am not able to read QVW file, please share a screenshot

Re: Different year value in a single bar with different color

Anil_Babu_Samineni — Wed, 22 Nov 2017 08:59:30 GMT

Yes, You need to plot the inside the data points and disable the option called "Show the total on Top" in the presentation tab.

Re: Different year value in a single bar with different color

Anonymous — Wed, 22 Nov 2017 09:06:54 GMT

i already done this.

Re: Different year value in a single bar with different color

Anonymous — Wed, 22 Nov 2017 09:07:43 GMT

please share a screenshot, i am not able to read qvw

Re: Different year value in a single bar with different color

Anil_Babu_Samineni — Wed, 22 Nov 2017 09:08:18 GMT

Have you enable the "Data points" for each expression?

Re: Different year value in a single bar with different color

Anonymous — Wed, 22 Nov 2017 09:11:30 GMT

yes

Re: Different year value in a single bar with different color

devarasu07 — Wed, 22 Nov 2017 09:22:02 GMT

Hi,

Refer,

Fact:
load *, Year(Date) as Year,Month(Date) as Month,Date(Date,'MMM-YY') as MonthYear;
LOAD * INLINE [
    Date, Sales
    31/1/2016, 40
    31/1/2017, 50
    20/2/2016, 45
    28/2/2017, 70
];

Bar chart->Style tab->Subtype 'Stacked'

try to create bar chart as like below way

1st dimension in your bar chart: Month &

add Year as 2nd dimension

expression;

sum(Sales)

after that enable data points for this expression tab

right clik your chart object and go to chart properties -->style--> subtype as Stacked

and then go to presentation enable check box as "Plot values inside segments"

Re: Different year value in a single bar with different color

Anil_Babu_Samineni — Wed, 22 Nov 2017 10:19:38 GMT

Can you attach QVW which demonstrates the O/P

Re: Different year value in a single bar with different color

Anonymous — Wed, 22 Nov 2017 11:01:01 GMT

please find attach file

Re: Different year value in a single bar with different color

Anonymous — Wed, 22 Nov 2017 11:31:48 GMT

but i need to show two different year and their same month in single bar

Re: Different year value in a single bar with different color

Anil_Babu_Samineni — Wed, 22 Nov 2017 11:47:36 GMT

Your values not showing because Height issue. You need to rid that using increase the height or showing in % values

Re: Different year value in a single bar with different color

Anonymous — Wed, 22 Nov 2017 12:02:22 GMT

it shows for only 2016 and 2017 but i have many years