topic Re: Qlik Sense Capabilities in App Development

Qlik Sense Capabilities

stxphxe — Sat, 25 May 2019 19:28:23 GMT

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

Re: Qlik Sense Capabilities

rwunderlich — Sat, 25 May 2019 21:49:28 GMT

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

Re: Qlik Sense Capabilities

stxphxe — Sat, 25 May 2019 22:22:22 GMT

Thank you!