Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Maximize ROI with Qlik Professional Services – Expert Guidance, Faster Results: Explore Qlik Services
cancel
Showing results for 
Search instead for 
Did you mean: 
chaitanyajami
Partner - Creator
Partner - Creator

qliksense chart selection issue

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

chaitanyajami_0-1588966763921.png

 

Labels (1)
0 Replies