Expression Help Getting "Others"

pnn44794 — Wed, 08 Nov 2017 21:15:44 GMT

Hello:

I have the following 3 existing expressions that provide the top 20 rows for VSI quantity, CPU's and Memory (GB). I now have an ask to add one more row of everything else combined for Foundation *=VSI or in other words, a Others row. Is this possible and if so, how would I do it?

Expression 1

If(Num(Rank(TOTAL Sum({<project_include_in_forecast = {1},project_is_active = {1},
estimate_include_in_forecast={1},estimate_is_active ={1}, [DM #]-= {'88888*'}, [Item Action]={'Add'} ,
Foundation *= {'VSI'}>} effective_item_qty))) < 21,
Sum({<project_include_in_forecast = {1},project_is_active = {1},
estimate_include_in_forecast={1},estimate_is_active ={1}, [DM #]-= {'88888*'}, [Item Action]={'Add'} ,
Foundation *= {'VSI'}>} effective_item_qty))

Expression 2

if(Num(Rank(TOTAL Sum({<project_include_in_forecast = {1},project_is_active = {1},
estimate_include_in_forecast={1},estimate_is_active ={1}, [DM #]-= {'88888*'}, [Item Action]={'Add'} ,
Foundation *= {'VSI'}>} effective_item_qty))) < 21,
Sum({<project_include_in_forecast = {1},project_is_active = {1},
estimate_include_in_forecast={1},estimate_is_active ={1}, [DM #]-= {'88888*'}, [Item Action]={'Add'} ,
Foundation *= {'VSI'}>} CPUs))

Expression 3

Expression 4????

Thanks in advance.

topic Expression Help Getting "Others" in QlikView

Expression Help Getting "Others"