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