Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
trishita
Contributor 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
Valued Contributor III

Re: Data mismatch in table and bar chart with same data percentage

is possible to share app

or what is ur bar chart second dimension

Channa
trishita
Contributor III

Re: Data mismatch in table and bar chart with same data percentage

Unfortunately i dont have access to share qvd.

Stack is Pension name

Bar is  Souce Kasse

Channa
Valued Contributor III

Re: Data mismatch in table and bar chart with same data percentage

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

Channa