Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Problem Loading Excel file

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

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: Problem Loading Excel file

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

View solution in original post

3 Replies
Highlighted
Not applicable

Re: Problem Loading Excel file

Hi,

could you post sample data and your application here?

You may need to use Qlikview Crosstable feature in data transformation

Highlighted
MVP
MVP

Re: Problem Loading Excel file

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.

Highlighted
Not applicable

Re: Problem Loading Excel file

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

View solution in original post