Fix a field value in table in qliksense

[sanjujeeboy]

I have field called Manufacturer which has 10 value. I want to display top 5 manufacturer with highest sales. 

Note: i want to always display One of the Manufacturer say 'A' even when its not in top 5.

how to achieve this?

Thanks

[anushree1]

You could try the below:

if(Manufacturer='A', Sum(Sales),if(rank(sum(Sales))<=5,Sum(Sales)))

If it does'nt work, suggest you to please share the sample, so that the expression precise to your requirement could be arrived at

[sanjujeeboy]

Category1			Category2
Manufacturer	Sales		Manufacturer	Sales
A	336,816,962.51		J	406,199,718.03
B	154,258,917.87		K	212,925,784.02
C	108,858,772.13		L	179,148,685.85
D	94,400,050.27		M	107,715,118.70
E	88,844,093.62		N	88,768,449.43
F	44,288,516.00		O	82,250,864.92
G	23,302,880.33		P	70,205,085.82
H	16,221,118.66		Q	69,911,473.04
I	9,508,814.67		R	66,120,828.65
			S	50,454,783.42
			T	46,787,536.58
			U	45,965,061.22
			A	43,923,497.42
			V	38,230,670.09

when sales sorted in decreasing order, If Manufacturer A is present in Top 5 , then display as it is,

if Manufacturer A  not present in top 5 then display Top 5 as well as Manufacturer A numbers

Thanks.

[anushree1 · Accepted solution]

The Expression Shared before works in this case,

Please check the attached

[sanjujeeboy]

with reference to qvf you have shared,can you show the output in 1st table itself instead of creating two tables.

[sanjujeeboy]

Hi

This solution worked.

Thanks.