topic Find Median for a row value in App Development

Find Median for a row value

elakkians — Tue, 27 Nov 2018 10:06:54 GMT

Hi All,

Need to find the median for the below data set in a straight table in qlik sense

Week 1	Week 2	Week 3	Week 4	Week 5	Week 6	Week 7
20	40	10	6	34	45	21

sunny_talwar — Tue, 27 Nov 2018 13:05:56 GMT

Is Week a dimension or do you have different columns for each Week? If Week is a dimension, try

Median(Data)

otherwise try

RangeFractile(0.5, Week1, Week2, Week3, Week4, Week5, Week6, Week7)

marcus_sommer — Tue, 27 Nov 2018 13:18:25 GMT

Maybe a pivot with week as horizontal dimension would be more suitable and then you could use something like:

median(aggr(YourExpression, Week, FurtherDimensions))

If these weeks are all different fields I suggest a transforming with a CROSSTABLE statement whereby you could also do it with something like:

rangefractile(0.5, [Week 1], [Week 2], ...)

- Marcus

elakkians — Wed, 28 Nov 2018 05:10:59 GMT

Thanks its working .