Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

stxphxe
New Contributor II

Qlik Sense Capabilities

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 excelHRV excel.png

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

 

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Qlik Sense Capabilities

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

2 Replies
MVP & Luminary
MVP & Luminary

Re: Qlik Sense Capabilities

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
New Contributor II

Re: Qlik Sense Capabilities

Thank you!