Total & Bar chart

[#1]

Hi everyone,

Probably, my questions was discussed many times, but spend more than 2 hours and cound not find the answer.

Siuation is very simple.

I have quaters in a row and sales number in columns like this:

Products   Q1 Q2 Q3

A              20  10  ...  

B              30  40 ...

C              30  ...  ...

D              15   ... ...

So, what I'd like to do is a bar chart with total amount for all products per quarter.

Now the bar chart shows amount for each separate product.

How can I make just a total bur for Q1.

It is easy to do in excel, powerpoint, but I need to do this in Qlik.

Thanks a lot.

[maxgro]

make a bar chart with no dimension and 4 expression, sum(Q1), sum(Q2), etc....

another option is to load your data with a crosstable  load

The Crosstable Load

and use the set analysis in the four expressions, something as

sum({$ <Quarter={Q1}>} Sales)

[jayanttibhe]

Like this ?  PFA.

[#4]

Thanks a lot, guys! "Dummy" Dimension works!