Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Qlikview - bar chart with multiple dimensions

I have straight table with lot of data...

enter image description here

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?

1 Solution

Accepted Solutions
MVP
MVP

Re: Qlikview - bar chart with multiple dimensions

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?

9 Replies

Re: Qlikview - bar chart with multiple dimensions

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

Not applicable

Re: Qlikview - bar chart with multiple dimensions

I edit my question

hirishv7
Honored Contributor

Re: Qlikview - bar chart with multiple dimensions

Hi,

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

Re: Qlikview - bar chart with multiple dimensions

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.

hirishv7
Honored Contributor

Re: Qlikview - bar chart with multiple dimensions

Hi,

Check this ,

Is this what you require,

Bar Chart with Mutliple Dimension-231184.PNG

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

Not applicable

Re: Qlikview - bar chart with multiple dimensions

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

hirishv7
Honored Contributor

Re: Qlikview - bar chart with multiple dimensions

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

MVP
MVP

Re: Qlikview - bar chart with multiple dimensions

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?

Not applicable

Re: Qlikview - bar chart with multiple dimensions

Thanks a lot!!!!!