topic Re: Bar chart in QlikView

Bar chart

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

Hi,

I have following bar chart:

M-Type is sum of M-Type and C-Type.

S-Type is sum of category S-type and M-Type.

This is something implicit and I don't know how to show this on chart.

Kindly help on how to modify this chart to indicate that M-Type has C-Type, S-Type has M-Type.

Thank you!

Re: Bar chart

shiveshsingh — Tue, 03 Apr 2018 17:03:44 GMT

Can u share ur app and expected o/p?

Re: Bar chart

ychaitanya — Tue, 03 Apr 2018 17:19:19 GMT

Hey ..

Can you try as below .. if i understood your requirement.

TEMP:

Load * INLINE

[

Parent_Type,Type

M_Type,M_Type

M_type,C_Type

S_Type,S_type

S_Type,M_Type

C_Type,C_Type

];

Attach this TEMP Table to your FACT/DIM table where you've Type

Then on the UI, draw the bar chart with Parent_Type as 1st DIM and Type as 2nd DIM

then Sum(Value).

Hope this Helps.

Thanks

Re: Bar chart

MarcoWedel — Tue, 03 Apr 2018 19:32:29 GMT

maybe you could stack the bars like this:

hope this helps

regards

Marco

Re: Bar chart

kinjal1645 — Tue, 03 Apr 2018 19:50:29 GMT

Thanks Marco

This looks good!

Can you let me know how to achieve this?

Re: Bar chart

MarcoWedel — Tue, 03 Apr 2018 20:13:10 GMT

Sure, can you post a sample application including some data and your expressions to demonstrate?

Re: Bar chart

kinjal1645 — Wed, 04 Apr 2018 22:02:18 GMT

marcowedel

I have attached sample application with data. It has one table and is not connected to other tables in my DB model.

Re: Bar chart

MarcoWedel — Fri, 06 Apr 2018 23:40:13 GMT

Hi,

example attached:

hope this helps

regards

Marco

Re: Bar chart

kinjal1645 — Mon, 09 Apr 2018 14:51:37 GMT

Thanks Marco!