Table customization

[Anonymous]

Good Morning,

I have created table in which My table shows the Top 15 client trends and remaining as Others.I just wanted to move the Unknown & Competion IBG from the Top 15 and add to the Others irrespective of the RTA$(shown below).Please suggest?

Rollover Destination	RTA $
FI	$176,368,433
CH	$49,327,118
VAN	$44,383,002
MOR	$30,092,771
UNKNOWN	$22,230,271
BAN	$21,506,932
AME	$21,052,990
EDW	$17,325,477
MERR	$16,351,848
AMER	$14,120,564
WELLS	$12,825,707
COMPETITION - IBG	$12,237,331
LINS	$8,709,050
UBS	$6,851,787
Ohters	$71,750,223

[Anonymous]

Hi Van I looking for some front end solution. In order to create those temp tables i have rerun my entire script loader...to avoid i am looking for the front end solution...can u plz suggest ?

[avkeep01]

Hi Surya,

For a front end solution I can't go without the rank column. That is the closest solution for your question.The solution is limited by the functionality in QlikSense.

For a back end solution you could make a binary load of the current application and add the script solution in the binary load. In that case it copies the model of your current application and then it runs the script I provided.

I don't think I can get any closer. Sorry for that. I wish I could fix it for you.

[Anonymous]

Sure i will try

[woshua5550]

I didn't get your point .. is this not your expected output ?

find example file attached in qvf format