Qlik Sense Capabilities

[stxphxe]

Hello,

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.

helppp

[rwunderlich · Accepted 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:

median(ColumnValue)
stdev(ColumnValue)

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[stxphxe]

Thank you!