Discussion board where members can get started with Qlik Sense.
wondering I create a histogram. the average price is around 20-100 but have one outlier (bad datapoint) about 4000
is that any easy way (only use dashboard) to exclude it then can make the histogram more pretty (in right scare)
Any suggesting methord to solve this without change underline data (loading data)
I try to use
in the data selection field but does not work. any suggestion? Thank you!
Since, this is a histogram, you won't be able to perform any calculation in the this particular chart. You have two options
1) Create a bar chart with your own buckets
2) Modify the script to create a new price field which already exclude the outliers. something like this
Left Join (Table)
LOAD Stdev(price) as StdevPrice,
Avg(price) as AvgPrice
If(price > AvgPrice - 3*StdevPrice and price < AvgPrice + 3*StdevPrice, price) as new_price
DROP Table Table;
I add a description in the data load editor
as hard coding this time. ---then I will change all the graph
but is there any way, I do not change loading data, but only use if() function to limited the data rang for the specific graph on dashboard? at the Data- Fields--prise--Field.
or should I create a variable in the dataset excluding this number (which may mean, if n>4000 then change it to 0)?
Use bar chart instead of histogram and you will be able to use the if statement