qliksense chart selection issue

chaitanyajami — Tue, 22 Jul 2025 14:29:37 GMT

Hi everyone,

i have two tables in qliksense where top one has numbers displayed at summary level and bottom table has numbers

in detailed level,when i make selection on the territory number results are displayed for both the charts and but when i make selections on the greyedout out or not associated territory number from search option from below table, the numbers in the first table are getting changed even though i ignore the selections on the territory number in the first chart expression which is below one, any way we can make the top chart to be static with the selection of the territory from the bottom table which is not associated ? thank you.

top table expression:

if(Geo_Table='Nation',Num(Sum({<BRAND={'MAVYRET'},REP_REGION={'HA','HB','HC'},METRIC_TYPE_NAME={'NBRX'},Week={">=$(=vCurrEndDate)<=$(=vCurrStartDate)"},
TERRITORY_NUMBER=,TERRITORY_FULLNAME=>}TOTAL_VOLUME),'#,##0'),
if(Geo_Table='Region',Num(Sum({<BRAND={'MAVYRET'},METRIC_TYPE_NAME={'NBRX'},Week={">=$(=vCurrEndDate)<=$(=vCurrStartDate)"},REP_REGION=p(REP_REGION),
TERRITORY_NUMBER=,TERRITORY_FULLNAME=>}TOTAL_VOLUME),'#,##0'),
if(Geo_Table='District',Num(Sum({<BRAND={'MAVYRET'},METRIC_TYPE_NAME={'NBRX'},Week={">=$(=vCurrEndDate)<=$(=vCurrStartDate)"},REP_DISTRICT=p(REP_DISTRICT),
TERRITORY_NUMBER=,TERRITORY_FULLNAME=>}TOTAL_VOLUME),'#,##0') ,
Num(Sum({<BRAND={'MAVYRET'},METRIC_TYPE_NAME={'NBRX'},Week={">=$(=vCurrEndDate)<=$(=vCurrStartDate)"},SEGMENT=,Top_Name=,PHYSICIAN=,TERRITORY_FULLNAME=>}TOTAL_VOLUME),'#,##0'))))

topic qliksense chart selection issue in Archived Groups

qliksense chart selection issue