topic Include "Others" In Striaght Table in QlikView

Include "Others" In Striaght Table

pnn44794 — Tue, 07 Nov 2017 01:24:14 GMT

Does anyone know how to include Others in a straight table? I have the following expression, which I need to include/combine all the others after the top 20. I'm guessing I need another Sum, but I'm not sure of the syntax. Then again, I could be wrong. The others should not include a DM # that begins with 88888.

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))

Re: Include "Others" In Striaght Table

marcus_sommer — Tue, 07 Nov 2017 12:57:09 GMT

I think you will rather need a calculated dimension (with aggr) or the features of the tab dimension limits. Take a look here what is meant: Show Top Performers.

- Marcus

Re: Include "Others" In Striaght Table

pnn44794 — Tue, 07 Nov 2017 14:23:41 GMT

Thank you Marcus. I will check it out. I also received your other reply to my other question, but I haven’t had a chance to check it out yet.

Re: Include "Others" In Striaght Table

pnn44794 — Tue, 14 Nov 2017 22:28:15 GMT

Hello Marcus:

Again, my apologies for the delay in replying. I did indeed check out the link you proved and it was very helpful. I've bookmarked it. Thank you for your response and help.