Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Theshantanu
Contributor
Contributor

How Can I get Excel Values of Excel as it is, in the Table ?

Hello, I am working on a dashboard in Qlik Sense. I have a Data set of 'Doctors' and each doctor has an estimated no. of 'Patients'.

So basically 1500 rows of unique doctors have a numeric value of estimated patients, and I have separately loaded this sheet in Qlik Sense. But when I try to insert this into a Table, and If I choose this as a Measure, it either Counts, Sums, Max. Min. or Avg. the Patients  .. But I want the exact same numeric value as in Excel corresponding to each doctor in the table. 

Is this possible ?

 

 

Labels (1)
1 Reply
Gabbar
Specialist
Specialist

It is because you are selecting it as a measure, therefore it is by default an aggregate function.
If you want to use it as it is,

you can put the same data as Dimension and you will get your result as you want

also you can use only function, but this might return null value where there are more than one value in data.