Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tiklabaq
Creator
Creator

Combo Chart: Stacked Bar Two Dimension >1 Expression

Hi Friends,

following problem:

I have a Combo Chart with two Dimensions.

1. Year

2. Product Group

In the Chart I want to show:

1. Expression:  per Year the sum of Amount per Product Group in stacked bar (sum(amount)

2. Expression: first Expression * 115% in Lines (sum(amount) * 1,15)

3. Expression: a fixed target value in Lines (This can possibly solved with a reference line in presentation)

QlikView makes automatically o grouped bar if I have a second expression.

There are over 100 product groups available, so I can't do it with set analysis for every product group.

thanks for your tips

4 Replies
Anil_Babu_Samineni

How is looking now?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
tiklabaq
Creator
Creator
Author

Hi Anil,

like this: This is only an Example with only 3 Product Groups.

Example.png

tiklabaq
Creator
Creator
Author

Anil, any idea?

Anil_Babu_Samineni

I may have idea or at least work around will work. But, Really mockup needed

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)