Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
trishita
Creator III
Creator III

Data mismatch in table and bar chart with same data percentage

I wanted to make a bar chart out of the same table chart but some reason the bar chart is not displaying the same data.

The percentage value is not right in the bar chart.

The percentage value for the table chart is just  Percentage=([HPV Buchwert])/([HPV Buchwert D]) where  HPV Buchwert D is a conditional loop statement  

 which is shown in the below picture in highlighted text

The percentage value for the bar chart  Percentage share=Sum( [HPV Buchwert])/Only(Sum(Total{$<Pensionseinrichtung, Stichtag_HPV = {'31.12.2018'}>}[HPV Buchwert]))*100.

For the bar chart  the two dimensions I have used are  Pensionseinrichtung and Source Kasse

I want that the  percentage column in table chart for percentage shows the same in bar and table chart.

Shares1.JPG

 

3 Replies
Channa
Specialist III
Specialist III

is possible to share app

or what is ur bar chart second dimension

Channa
trishita
Creator III
Creator III
Author

Unfortunately i dont have access to share qvd.

Stack is Pension name

Bar is  Souce Kasse

Channa
Specialist III
Specialist III

the difference is because of dimensions used in both chart and table

Channa