topic Re: Total problem in pivot table in QlikView

Total problem in pivot table

sarfaraz_sheikh — Wed, 21 Oct 2015 11:25:27 GMT

Dear All ,

I am facing the problem regarding total...

As of now Total looking like below:

Output Total Should be like below:

Total Amount 25140548 557844 -98

Count 628 15 -98

If we see in above format TOTAL is showing only for count after checking on show partial sum over RoleName Dimension...........But it should apears for both Amount and Count ...Strange behaviour...

Can any one help me with this ..............

My QVW is also attached here for your reference.........

gwassenaar‌, jagan‌ , hic‌ please comment

Sarfaraz

Re: Total problem in pivot table

sujeetsingh — Wed, 21 Oct 2015 11:33:51 GMT

For explicitly doing this you need some changes and tricks. Well check whether this will do

Re: Total problem in pivot table

prashantbaste — Wed, 21 Oct 2015 11:41:43 GMT

Hi Sarfaraz,

Are you comfortable with below output...

If yes... check Attached QVW.

Changes made in Presentation are Tab -> Show Partial Sums -- Select Dimension & Expression by which Total is expected.

Re: Total problem in pivot table

krishna20 — Wed, 21 Oct 2015 11:44:32 GMT

Hi,

Is this your expected output....??

Re: Total problem in pivot table

sarfaraz_sheikh — Wed, 21 Oct 2015 11:53:28 GMT

Hi Prashant,

Thanks for your efforts .........I already tried what you have done but that is not a expected output ....

Expected output should be like below....

Sarfaraz

Re: Total problem in pivot table

sarfaraz_sheikh — Wed, 21 Oct 2015 12:00:47 GMT

no... not expected output ...both should show in one Table only....is this possible.....

Sarfaraz

Re: Total problem in pivot table

prashantbaste — Wed, 21 Oct 2015 12:28:36 GMT

You will need to make a small change in Script.

Join 'Total' to your data as -

Load Distinct StatusCount, StatusCount as NewField from table1;

Join

Load StatusCount, 'Total' as NewField from table1;

Now use this NewField in dimension and write expressions (with respect to StatusCount) this will display values for individual level as well as Total level.

Hope this will be helpful for you.

Re: Total problem in pivot table

prashantbaste — Wed, 21 Oct 2015 12:41:22 GMT

Please find attached QVW ... this is the solution that you are looking ... Right?

Re: Total problem in pivot table

nikhilgarg — Wed, 21 Oct 2015 12:41:46 GMT

Hey,

Is this acceptable? See the snapshot attached.

Re: Total problem in pivot table

sarfaraz_sheikh — Wed, 21 Oct 2015 14:31:53 GMT

Dear Prashant,

Thanks for your efforts...

I go the solution as expected ..........be grateful to you ......Great work.

Sarfaraz