HOW TO IGNORE FIELDS IN EXPRESSION IN BAR CHART?

Tue, 28 Jul 2015 15:37:30 GMT

=if(getcurrentfield(GeoAreaRegionTerritory) = 'GEO_DISPLAY',

Count([Quadrant_Pos]) / Count ({<[Quadrant_Pos]= p([Quadrant_Pos])>} total<[GEO_DISPLAY]> [Quadrant_Pos]),

if(getcurrentfield(GeoAreaRegionTerritory) = 'AREA_DISPLAY',

Count([Quadrant_Pos]) / Count ({<[Quadrant_Pos]= p([Quadrant_Pos])>} total<[AREA_DISPLAY]> [Quadrant_Pos]),

if(getcurrentfield(GeoAreaRegionTerritory) = 'REGION_DISPLAY',

Count([Quadrant_Pos]) / Count ({<[Quadrant_Pos]= p([Quadrant_Pos])>} total<[GEO_DISPLAY],[AREA_DISPLAY]> [Quadrant_Pos]),

Count([Quadrant_Pos]) / Count ({<[Quadrant_Pos]= p([Quadrant_Pos])>} total<[GEO_DISPLAY],[AREA_DISPLAY],[REGION_DISPLAY]> [Quadrant_Pos]),

)))

in the below image when I click on Geo level, it goes to next level area and each area has it own 100% bar

but when I am clicking on 46%(red-NA) (i.e; any legend color), then it is showing me 100% , but the requirement is to get count of % of 46% in each area(i.e; NM/GW+PLAT+PS/CAN=46%/100%), how can we modify the expression to get this requirement.

THANKS IN ADVANCE

attached a sample file, similar to the requirement

Re: HOW TO IGNORE FIELDS IN EXPRESSION IN BAR CHART?

qlikviewwizard — Tue, 28 Jul 2015 16:42:12 GMT

Can you attach the sample file, please. Thank you.