topic Re: Set Analysis - stacked bar chart question in QlikView

Set Analysis - stacked bar chart question

Mon, 05 Nov 2012 15:31:30 GMT

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!

Re: Set Analysis - stacked bar chart question

Mon, 05 Nov 2012 15:37:23 GMT

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

Best regards,

TMF

Re: Set Analysis - stacked bar chart question

Mon, 05 Nov 2012 15:39:21 GMT

Thanks for the reply

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

Re: Set Analysis - stacked bar chart question

Mon, 05 Nov 2012 16:55:07 GMT

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

Re: Set Analysis - stacked bar chart question

Mon, 05 Nov 2012 16:57:46 GMT

Thanks, but I have now resolved this.

Re: Set Analysis - stacked bar chart question

Tue, 06 Nov 2012 08:52:59 GMT

cheers mate