I want create a bar chart in qlikview with the help of excel file.

[onkarkulkarni]

I have above data.

My requrement is - I need a bar chart with sum of counts of entries in Type1.....Type5 columns  on X axis and Count of Person on Y axis.

X axis should have bars for  0 ,1,2,3,4,5

For example only one person has entries in all five type columns.so last bar will show count =1.

two perosn 20 & 24 has values in 4 columns ..so bar for 4 shoud show count 2.

I have tried to create a expected design

[Anonymous]

Hi

Please attach excel file

[Anil_Babu_Samineni]

May be use Force 0 for dimension level with Continuous option