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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

how can we achieve that?

thanks in advance

1 Solution

Accepted Solutions
MarcoWedel

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

View solution in original post

10 Replies
MK_QSL
MVP
MVP

Expression Tab

Select Expression

Click On Group Button

sorrakis01
Specialist
Specialist

Hi,

What you do expect?

Regards

Not applicable
Author

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
Specialist
Specialist

Hi,


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


sorry i don't understand your goal.


Regards

Not applicable
Author

GeoAreaRegionTerritory is a group

which i want to replace [GEO_DISPLAY] with

settu_periasamy
Master III
Master III

Hi,

try this

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

Not applicable
Author

hi settu,

    This did not work

sorry

Not applicable
Author

color1.PNG

Not applicable
Author

color2.PNG

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)