# Qlik Sense App Development

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for
Did you mean:
Highlighted
Contributor III

## Median QlikSense

I have another scenario :

t1:
[
Year,Region,Impact
2018,India,Low
2018,SriLanka,Low
2018,Australia,Significant
2018,Japan,Low
2019,India,Low
2019,SriLanka,Low
2019,SriLanka,Significant
2019,India,Medium
2019,Australia,Low
2019,India,Significant
2019,UK,Significant
2019,UK,Low
];

Here we need to consider the same year and also Impact equal to Significant

For example in 2018 it will be,
India = 0
Sri Lanka = 0
Australia - 1
Japan - 0

Median will be zero

In 2019,
India - 1 (Impact is equal to Significant in one case)
SriLanka - 1 (Impact is equal to Significant in one case)
Australia - 0 (Impact is equal to Significant in zero case)
UK - 1 (Impact is equal to Significant in one case)

Median for 0,1,1,1 which is 1

Labels (2)
• ### Qlik Sense

3 Replies
Highlighted
Contributor III

Hello all,

Thanks & Regards,

Arvind

Highlighted

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Contributor III

Hi Jonty,

Thanks for the response.

I have below scenario :

t1:
[
Year,Region,Impact
2018,India,Low
2018,SriLanka,Low
2018,Australia,Significant
2018,Japan,Low
2019,India,Low
2019,SriLanka,Low
2019,SriLanka,Significant
2019,India,Medium
2019,Australia,Low
2019,India,Significant
2019,UK,Significant
2019,UK,Low
];

Here we need to consider the same year and also Impact equal to Significant

For example in 2018 it will be,
India = 0
Sri Lanka = 0
Australia - 1
Japan - 0

Median will be zero

In 2019,
India - 1 (Impact is equal to Significant in one case)
SriLanka - 1 (Impact is equal to Significant in one case)
Australia - 0 (Impact is equal to Significant in zero case)
UK - 1 (Impact is equal to Significant in one case)

Median for 0,1,1,1 which is 1