Discussion board where members can learn more about Qlik Sense App Development and Usage.
I am new to Qlik sense and after watching videos in the continuous classroom I am still struggling to use it to perform my calculations.
This is my data in excel
I want to calculate the mean value for each date. So, for example the mean of values that fall under '31/07/2017' and the values fall in separate columns as shown above.
I then want to calculate the Standard deviation for each date.
Go to Solution.
You'll want to start by doing a CrossTable Load to convert those columns to rows.
1. Generate a Load statement for the file using the select data dialog in the data load editor.
2. Add this prefix to the Load Statement:
CrossTable (ColumnName, ColumnValue, 2) Load Date,[Raw HRV},[Column1],...etc
3. After executing the load, you'll have a table with 4 columns: Date, [Raw HRV], ColumnName, ColumnValue.
4. Make a chart with Date as the dimension. For the chart measures you can use aggregation functions such as: