Qlikview - bar chart with multiple dimensions

[#1]

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?

[Anil_Babu_Samineni]

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

[#3]

I edit my question

[HirisH_V7]

Hi,

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

[Anil_Babu_Samineni]

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.

[HirisH_V7]

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

[#7]

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

[HirisH_V7]

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

[sunny_talwar · Accepted solution]

Can you try to add this as the dimension:

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

or

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?

[#10]

Thanks a lot!!!!!