Problem Loading Excel file

[#1]

Hi Community,

I am loading a pivot type excel file into qlikview,However in few fields I am not getting the full data which is present in excel.Please help me in identifying the problem as I am stuck with this from long time.

Thanks in advance

Regards

Murali Krishna

[#2]

Hi,

could you post sample data and your application here?

You may need to use Qlikview Crosstable feature in data transformation

[swuehl]

Not sure how we are supposed to help here with this amount of information given. We neither know your input data nor your QV load script.

[#4 · Accepted solution]

I have forgot to uncheck 'Supress Null Values' option,So that all null data disappeared.Now evertthing looks good.