If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
This seems pretty straight forward but it does not seem to work.
I have a numeric field and would like to calculate the standard deviation in a KPI.
Field Name : AmountSpent
Thoughts ? Jerryr
1. I am getting an "Invalid Dimension" error.
3. No null values
* Note: I am using the same field for Min, Max and Average KPI - no issues.
Strange; try rebuild the aggregation in the KPI object
Something like this:
replace avg with the aggregation you are performing (if none, just use only()) and YourDimension with the relevant dimension
Hi - I tried this :
Again - no luck.
In my data, I have a field 'AmountSpent' in which I would like the Average, Min, Max and Standard Deviation.
There is no null values - only numbers > 0.00
I would like to display this as a KPI
Any thoughts ? Jerry