Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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.