Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
pascos88
Creator II
Creator II

Strange view for char

Hello,

I have a strange view in a chart.

I have the dimension with 8 field and the expression that I put it is down.

Why the chart show my the chart divided in two Part? I dont want the part in red (100%) that is the sum of the other part.

Someone can help me?

Thanks in advance

errorScr.pngz

9 Replies
pascos88
Creator II
Creator II
Author

sorry my dimension is with 6 field, those in different color in the right part of the chart

pascos88
Creator II
Creator II
Author

I just seen one important thing.

If my "add Calculated dimension" is

=if(vChart=0,Cat,if(vChart=1,Category))

the parameter which calculates the total doesn't appear.

when I put an expression like this

=if(vChart=0,Cat,if(vChart=1,Category,if(vChart=2,Category Feb,)))

I will have the same situation of before. I have another parameter that show me the total of all.

buzzy996
Master II
Master II

if i'm not wrong that 100% is showing because of ur last else condition in the above if expression.

if possible u can share ur app,that helps to quickly reply!

simospa
Partner - Specialist
Partner - Specialist

Ciao Pasquale,

try to share a part of your qvw application.

What does vChart variable contain?

Which kind of fields are you using as dimensions?

Also consider that the Ref Manual says that Pie Charts cannot display more than two dimensions. It may be random behavior of situations that the Pie Chart object isn't designed to handle...

S.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Can you post your QVW?

pascos88
Creator II
Creator II
Author

I just have a Trial version. Is possible share file.qvw with this? I don't find the way to do it..

pascos88
Creator II
Creator II
Author

Hello Simone,

I try to changhe chart but with same expression. The result is the same I always have a part of the chart that show me the total.

The last bar I don't know why is show.

errscr1.png

simospa
Partner - Specialist
Partner - Specialist

Ciao Pasquale,

use advanced editor to post your qvw on the form.

S.

Not applicable

try this one,If it is not working please share your excel fileUntitled.png