Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
amber2000
Creator
Creator

Problem with % expression in chart


Hello everyone,

I'm strugling again with creating an expression in a chart.

I have 3 fields called Zone ,Tendu/Stock and Colli.

I want to see by Zone how may % is Tendu and how many % is Stock in a chart.

No clue what so ever on how I can manage this, can someone help me please, I've attached the QVW with the data.

Kind regards,

Monique

1 Solution

Accepted Solutions
mov
Employee
Employee

12 Replies
Not applicable

Are you trying to see by zone what percent of the colli are stock or tendu?

amber2000
Creator
Creator
Author

Yes that's what I'm trying to see but I want to see both Stock %  and Tendu %

Both accumulated should be 100%

maxgro
MVP
MVP

if you want this

- remove dimension Colli

- add expression  Sum(Colli) / sum(TOTAL <Zone> Colli)

and format in Number tab

if not, you probably have to play with the TOTAL

1.png

mov
Employee
Employee

See attached

venkatg6759
Creator III
Creator III

Check if this helps .

Not applicable

Like this?

alexpanjhc
Specialist
Specialist

I hope this helps.

amber2000
Creator
Creator
Author

Thank you so much, can you explain to me how the expression is working step by step please?

I don't just want to copy code but try to understand so I can manage these things myself.

Monique

amber2000
Creator
Creator
Author

Yes this is very clear but I've seen a different way of expression that is not completly clear to me:

sum([Colli]) / Sum(TOTAL<Zone>Colli)