Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Re: Set Analysis - stacked bar chart question

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

Re: Set Analysis - stacked bar chart question

Thanks for the reply

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

Not applicable

Re: Set Analysis - stacked bar chart question

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

Re: Set Analysis - stacked bar chart question

Thanks, but I have now resolved this.

Not applicable

Re: Set Analysis - stacked bar chart question

cheers mate