exclude field in selection

sbkumar — Wed, 25 Nov 2020 16:16:04 GMT

hi friends

For an application, I need to ignore a certain search filter using Set Analysis into an aggregate function.

The AGGR function is:

Aggr(
if(rank(sum({<$(vTime_Frame)={1}, [Therapeutic Category] = {$(vMarketValue)},Territory=>}TRX)/sum({<$(vTime_Frame)={1},[Therapeutic Category] = {$(vMarketValue)},Territory=>} Total <IMS_ID_Searchable> TRX))<=5,
(sum({<$(vTime_Frame)={1}, [Therapeutic Category] = {$(vMarketValue)},Territory=>}TRX)/sum({<$(vTime_Frame)={1}, [Therapeutic Category] = {$(vMarketValue)},Territory=>}Total<IMS_ID_Searchable>TRX))),IMS_ID_Searchable,[Payer Channel])

if i remove Territory= data is coming correctly,if i include Territory= ,it is showing as NO Data to display.

Finally I need to Include Territory in the expression.

Re: exclude field in selection

Rodrigo_Reis — Wed, 10 Jul 2019 14:37:33 GMT

Can you upload an example with data?

topic Re: exclude field in selection in QlikView

exclude field in selection

Re: exclude field in selection