Skip to main content
Announcements
You can succeed best and quickest by helping others to succeed. Join the conversation.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Histogram with multiple dimensions and expressions

Hello,

i need to display a histogram with 3 expressions( Sales, Budget,sales N-1)  and 2 dimensions (Year , Product) like this:

the dimension Year in the axis X but the product (EMN,EDT,SOD,PRF) on the bar. and the expressions are on different bar, how can i do this ??

qlik.pngBe

because when i ve tried to do it in qlikview the result i get is this : both of the dimension are on the axis X, and the expressions are on the same bar

qlik2.png

7 Replies
Anonymous
Not applicable
Author

any help please?

sharpjoki
Contributor II
Contributor II

Hi.

On the "Style" tab in the chart properties, you must select SubType -> Stacked.

Anonymous
Not applicable
Author

thank you for your answer, I have already  test that option but there is no change i have the same result as the second image posted.

Any other suggestions please?

sharpjoki
Contributor II
Contributor II

Attach please qvw with the chart.

Anonymous
Not applicable
Author

thank you for your answer , but i really can't share the qvw , the data is so confidential.

i have capture all the parameters hope its clear

thank you

tqlik5.png

qlik6.pngqlik7.pngqlik8.png

sharpjoki
Contributor II
Contributor II

Sorry, I confused, on the "Style" tab in the chart properties, you must select Sous-Type-> Groupe.

Anonymous
Not applicable
Author

Thank you but when i select "groupe" as "sous type", it gives this:qlik9.png

its not the structure  that i want, here is the result i want : the different KPI on X axis , and the dimension on the bar with different colors

qlik.png