Solved: how can I get group in the expression for bar char... - Qlik Community

Report Inappropriate Content · ‎2015-07-27

how can I get group in the expression for bar chart?

how can we achieve that?

thanks in advance

MarcoWedel · ‎2015-07-27

just add all Fields that are included in the GeoAreaRegionTerritory-Group to your total qualifier:

Count([Quadrant_Pos]) / Count(total<Geo, Area, Region, Territory> [Quadrant_Pos])

if not working, please post sample app.

hope this helps

regards

Marco

MK_QSL · ‎2015-07-27

Expression Tab

Select Expression

Click On Group Button

sorrakis01 · ‎2015-07-27

Hi,

What you do expect?

Regards

Report Inappropriate Content · ‎2015-07-27

as per the requirement:

I have a group called geo in dimension

i want that in the expression

Count([Quadrant_Pos]) / Count(total<[GEO_DISPLAY]> [Quadrant_Pos])

GeoAreaRegionTerritory= this is the group which I want in the expression or

can this expression can be re-written

sorrakis01 · ‎2015-07-27

Hi,

GeoAreaRegionTerritory is another dimension? or you will replace [GEO_DISPLAY] to GeoAreaRegionTerritory,

sorry i don't understand your goal.

Regards

Report Inappropriate Content · ‎2015-07-27

GeoAreaRegionTerritory is a group

which i want to replace [GEO_DISPLAY] with

settu_periasamy · ‎2015-07-27

Hi,

try this

Count([Quadrant_Pos]) / Count(total<$(=GetCurrentField('GeoAreaRegionTerritory'))> [Quadrant_Pos])

Report Inappropriate Content · ‎2015-07-27

hi settu,

This did not work

sorry

Report Inappropriate Content · ‎2015-07-27

Report Inappropriate Content · ‎2015-07-27

when I click on 46% in NA, then next level I am getting like this

but the requirement is to get the sum of all 3 (NM/GW, PLAT, PS/CAN)