topic Re: Barchart in QlikView

Barchart

danosoft — Wed, 08 Aug 2018 09:47:13 GMT

how can i do i chart like this in qlikview?

i need an example with some bars in stack

mtucholski — Wed, 08 Aug 2018 10:09:38 GMT

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 — Wed, 08 Aug 2018 10:18:52 GMT

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 — Wed, 08 Aug 2018 10:39:45 GMT

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 — Thu, 16 Aug 2018 09:55:38 GMT

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 — Thu, 16 Aug 2018 10:05:18 GMT

If you are you looking for water fall chart

danosoft — Thu, 16 Aug 2018 10:10:05 GMT

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