Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis - stacked bar chart question

Hello

I have a stacked bar chart with multiple expressions which I need to show the contribution of several groups of data to a total. I am using the following expression:

 

sum({$<CollsFlag={1},RPC={1},TranfAMFlag={1},Group={"Closure"},RemoveFlag={0}>}Closure) / sum({$<CollsFlag={1},RPC={1},TranfAMFlag={1},RemoveFlag={0}>}RPC

)

For each group of data I am changing the={"Closure"} part to match another of the groups. This worked fine until today when I corrected the join between the inline table defining the different groups as it was brining through duplicates. Now it has stopped showing any group other than the Closure. I have tried cutting and pasting the expression that works over the ones tat do not but this doesn't help.

Thanks in advance for your help!

5 Replies
Not applicable
Author

Hi

In your Table View, when you do a preview of data you can see more than the group 'Clousure' ?

Best regards,

TMF

Not applicable
Author

Thanks for the reply

Yes, I can see all groups but they all show 0.0% other than Closure

Not applicable
Author

It sounds like closure will only be 1 when it is a closure so if you sum this, it will only sum closure.

I think you need to remove the Closure = 1 part if you want to show others.

You should do a count of group rather than count of closures.

Let me know if you need anything else

Not applicable
Author

Thanks, but I have now resolved this.

Not applicable
Author

cheers mate