topic Re: Qlikview - bar chart with multiple dimensions in QlikView

Qlikview - bar chart with multiple dimensions

Mon, 26 Jan 2026 18:19:17 GMT

I have straight table with lot of data...

I need to create bar chart from this table - dimension to be year and expressions Column(1)-Column(2).

column(1) = sum(Saldo) column(2) = sum(Saldo)/3

I try to set dimension to be year and expresion

sum(sum(Saldo) - (sum(Saldo)/3))

but I don't get same total like I get sum of rows of Column(1)-Column(2).

This is because I need to include in dimension Line.

How can I create bar chart with dimensions I have in straight table...?

Any idea?

Re: Qlikview - bar chart with multiple dimensions

Anil_Babu_Samineni — Thu, 01 Sep 2016 08:46:59 GMT

Can you please post sample Application. And you are saying you are not getting the same values in Bar chart. Can i know which values wrong as you imagine. Better way to approach please share qvw

Re: Qlikview - bar chart with multiple dimensions

Thu, 01 Sep 2016 08:57:02 GMT

I edit my question

Re: Qlikview - bar chart with multiple dimensions

HirisH_V7 — Thu, 01 Sep 2016 09:04:34 GMT

Hi,

Can you please post your sample data in a excel file and elaborate your requirement.

Re: Qlikview - bar chart with multiple dimensions

Anil_Babu_Samineni — Thu, 01 Sep 2016 09:08:33 GMT

I am not getting any diff after updating. Why not create simple Bar chart and use Drill Down / Cyclic. An use same expression over there Directly.

Re: Qlikview - bar chart with multiple dimensions

HirisH_V7 — Thu, 01 Sep 2016 09:25:53 GMT

Hi,

Check this ,

Is this what you require,

Using expression as marked above in the image,

yours complete expression will not work,

sum(sum(Saldo) - (sum(Saldo)/3)) it will through error as exceeding limits.

HTH,

PFA,

Hirish

Re: Qlikview - bar chart with multiple dimensions

Thu, 01 Sep 2016 09:40:33 GMT

And how to include dimension Line from straight table in expressions, Is there any way?

Re: Qlikview - bar chart with multiple dimensions

HirisH_V7 — Thu, 01 Sep 2016 10:01:27 GMT

I didn't get you exactly,

Already dimension year is currently appearing on bar chart right?

Please elaborate your requirement, What you need to see on bar chart!!

-Hirish

Re: Qlikview - bar chart with multiple dimensions

sunny_talwar — Thu, 01 Sep 2016 10:59:11 GMT

Can you try to add this as the dimension:

Aggr(Sum(Aggr(Sum(Saldo) - (Sum(Saldo)/3), Document, Year, Line)), Year)

Aggr(Sum(Aggr(Sum(Saldo) - (Sum(Saldo)/3), Document, Year, Line, Itam, Unit)), Year)

If they both don't work, would you be able to provide a sample qvw file to look at?

Re: Qlikview - bar chart with multiple dimensions

Thu, 01 Sep 2016 12:02:34 GMT

Thanks a lot!!!!!