topic Re: Re: Re: Percentages in pivot table in QlikView

Percentages in pivot table

Tue, 08 Oct 2013 06:40:44 GMT

Hi,

A simple question.

The pivot table has two dimensions. How do I get fractions of the new concepts to total concepts in a period ? and also old concepts to total concepts and sums of concepts in each period.

Re: Percentages in pivot table

Gysbert_Wassenaar — Tue, 08 Oct 2013 06:46:45 GMT

You'll need to use the total keyword in your expression. You didn't post any data so I'll have to guess. It would be something like sum(Concepts)/sum(total <Quarter> Concepts). For the totals you can enable Partial Sums on the Presentation tab of the properties window of the pivot table.

Re: Percentages in pivot table

Tue, 08 Oct 2013 06:51:01 GMT

The point is if what you said is used as an expression, it is getting calculated twice as there are two dimensions to the pivot table. Should I drag this expression to the corner or something on the front end ?

Re: Percentages in pivot table

Tue, 08 Oct 2013 06:52:08 GMT

Re: Percentages in pivot table

Gysbert_Wassenaar — Tue, 08 Oct 2013 06:55:13 GMT

Since you're using count in your expression the division should use count as well. Dividing a count by a sum doesn't make sense. If you need more help you will have to post the document you're working on. Read this document for how to do that safely: Preparing examples for Upload - Reduction and Data Scrambling

Re: Re: Percentages in pivot table

Tue, 08 Oct 2013 07:00:09 GMT

PFA

Re: Re: Re: Percentages in pivot table

Gysbert_Wassenaar — Tue, 08 Oct 2013 07:03:41 GMT

PFA

Re: Re: Percentages in pivot table

Tue, 08 Oct 2013 07:07:25 GMT

I use a personal edition of QV. I cant have a look at the QVW you sent.

I got the answer to it anyways.

Kindly post a screenshot of the expressions tab if possible i'll cross check.

Thanks!

Re: Percentages in pivot table

Gysbert_Wassenaar — Tue, 08 Oct 2013 07:13:09 GMT

I've added a second expression to calculate the percentages and added Partial Sums for the NewConcept dimension. I've also formatted the second expression on the Number tab so the values show as percentages.

Re: Re: Percentages in pivot table

Tue, 08 Oct 2013 07:18:05 GMT

Thanks for your time!

Re: Percentages in pivot table

Tue, 08 Oct 2013 07:26:25 GMT

How to get the concepts that are not unique in jan & not unique in april & not unique in Jul & not unique in Oct ??

Re: Percentages in pivot table

Tue, 08 Oct 2013 07:29:47 GMT

HOw do I identify concepts that have died out over time ?

and the concepts that have sustained over the entire time frame ?