Barchart

[danosoft]

how can i do i chart like this in qlikview?

i need an example with some bars in stack

[mtucholski]

Hello, find the example enclosed. At first create a chart, then select 'Bar chart' in 'General' tab and select 'Stacked' in 'Style' tab.

\

Have fun

[danosoft]

Ok but i am in this situation, see the example i attach:

- I want the first and second bar are in a stack

- i want the third an fourth bar are in another stack

- fifth, sisth and seventh in another stack

how can i do that?

[mtucholski]

You have no dimension in your chart, that is the problem. What have I done?

1. Added another table with your "STATO_IN" grouped as you wanted them to be (check the script).

2. Added STATO_IN_group and STATO_IN to dimension.

3. Removed set analysis from expression, leaving just sum(CONSUMO_TOT_ANNUO).

4. Set bar chart to Stacked.

You will get it .

[danosoft]

Ok, thanks, but my example is more complex, look at the attachment i send now....

i not have only STATO_IN for making group, in my expressions i use set analisys withouth using stato_in (like you see in the first bar for example).

And i have some Expressions where i user STATO_OUT and some set analisys with the dates

look at example, thanks

[dsharmaqv]

If you are you looking for water fall chart

How do you create a stacked waterfall chart

[danosoft]

Yes but how can i do that with my example i sent?

- I want the first and second bar are in a stack

- i want the third an fourth bar are in another stack

- fifth, sisth and seventh in another stack

how can i do that with this example i attach?

i use some different expression for every bar