topic How to show highest Risk . Part 2 in QlikView

How to show highest Risk . Part 2

Anonymous — Mon, 18 Dec 2017 03:08:03 GMT

In the last question , you guys helped me with this . Luis, and other friends.

As shown in the picture. Apple belongs to different sectors but calcuation FirstSortedValue(Risk,-Level) skips some of apple. i am having this same issue.

Also i want to be able to show and divide by sectors . Later on I will be making a pie chart that shows sectors and their risk ratings based on their seller symbols.

Seller Symbol	Sector	Risk	Level
Sysco	Food	High	3
Baskin Robbins	Food	Low	1
Methodist	Health	Very High	4
Dillards	Retail	Medium	1
Apple	WholeSale	High	3
Apple	Retail	Medium	1
Methodist	Food	Low	1
Methodist	Health	High	3
WWE	Retail	Medium	1
Shop N Save	Food	High	3
Kroger	Health	High	3
Hermann	Retail	Very High	4
Baskin Robbins	WholeSale	Medium	1
Methodist	Retail	High	3
Dillards	Food	Medium	1
Apple	Health	Low	1
Apple	Retail	Very High	4
Baskin Robbins	WholeSale	Medium	1
Methodist	Retail	High	3
Dillards	Health	Medium	1
Apple	Retail	Very High	4
Baskin Robbins	WholeSale	Medium	1
Methodist	Retail	High	3
Dillards	Health	Very High	4
Apple	Retail	Medium	1
Baskin Robbins	WholeSale	Very High	4
Methodist	Retail	Medium	1
Dillards	Food	High	3
Apple	Health	Medium	1
Baskin Robbins	Retail	Low	1
Methodist	WholeSale	Very High	4
Dillards	Health	Medium	1
Apple	Retail	High	3
Apple	WholeSale	Medium	1
Methodist	Retail	Low	1
Methodist	Food	High	3
Methodist	Health	Medium	1

Re: How to show highest Risk . Part 2

luismadriz — Mon, 18 Dec 2017 03:57:15 GMT

Hi Mike,

Create first two dimensions:Seller Symbol and Sector, then this dimension:

=Aggr(FirstSortedValue(DISTINCT Risk,-Level),[Seller Symbol],Sector)

Please confirm is this is what you're after in terms of the data

Cheers,

Luis

Re: How to show highest Risk . Part 2

tamilarasu — Mon, 18 Dec 2017 04:22:37 GMT

Hi Mike,

Try this,

Aggr(FirstSortedValue(Distinct Risk,-Pick(Match(Risk,'Low','Medium','High','Very High'),1,2,3,4)),[Seller Symbol],Sector)

Re: How to show highest Risk . Part 2

Anonymous — Mon, 12 Feb 2018 02:45:35 GMT

I used the calculation. it works fine on qlik desktop but is not showing up on qlikview server.

I used this in a pie chart to be clear.

I used that calculation as a calculated dimension and for expression did a count.