topic Re: 2 Expressions in Pivot Chart in QlikView

2 Expressions in Pivot Chart

yashcena — Fri, 30 Jun 2017 07:00:54 GMT

I'm showing the count of defects (state-wise) and I'm showing them horizontally. I want to add one more column which will show me the total count of defects.

For example, in CR4594 Lion, I'm able to see the count of defects which are fixed(2), open(5)....submitted(11). I also want to see the total count of defects for CR4594 which should be 2+5+10+4+11= 32.

Is there any way to have the 2nd expression NOT split state-wise? I hope I have made my requirement clear.

Thanks,

YASH

Re: 2 Expressions in Pivot Chart

hector_munoz — Fri, 30 Jun 2017 07:36:05 GMT

Hi Yash,

UHave you tried to use set analysis? Something like: Count({<Status>} Defects)

Above you donot take into account selections in Status field.

Regards,

Re: 2 Expressions in Pivot Chart

kaushiknsolanki — Fri, 30 Jun 2017 07:37:22 GMT

Hi,

Just try to add the total for the State level.

Go to Properties -> Presentation Tab-> Select State -> Check the box "Partial Sums" -> Click OK.

Regards,

Kaushik Solanki