Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Lucky1
Creator
Creator

Data count wrong while extracting the data into excel

Hi Team,

 

I have a table in qliksense  i dont have any measure i have only dimensions id name ......

When i download qliksense table to excel format it is not giving the exact number which iam getting in qliksense.

My qliksense is giving correct count.What might be the cause

 

 

 

Labels (5)
3 Replies
Chanty4u
MVP
MVP

Hi ,

May be you have one to many relationships in your data ..

Can you attach the sample data to test 

Lucky1
Creator
Creator
Author

Sorry I cannot share it's confidential data.in qliksense it is showing correct after extracting data it is showing 2181 rows.it should be 2185.in qliksense table it is showing 2185 only

marcus_sommer

All objects in Qlik show always the distinct combination of the included fields. And all aggregations like sum() or count() would respect any duplicates of data within their results but if you just exports such object and counts against the values within the rows you may miss any of these duplicates.