Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

HOW TO IGNORE FIELDS IN EXPRESSION IN BAR CHART?

HOW TO IGNORE FIELDS IN EXPRESSION IN BAR CHART?

=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]),

  )))

  • THIS IS THE EXPRESSION USED
  • THERE IS A DRILL DOWN GROUP =(GeoAreaRegionTerritory)
  • Quadrant_Pos= LEGENDS

PIC1.PNG

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

PIC2.PNG

  • 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.

PIC3.PNGTHANKS IN ADVANCE