topic Re: Final Total Caluculation in QlikView

Final Total Caluculation

HirisH_V7 — Thu, 05 Nov 2015 09:35:12 GMT

Hi all,

Here in the attached application .

I want to create performance Grand Total . It should be sum of all Clp* Performance Of all states.i created like that . But when i select a single State its showing wrong performance.

Please help me out .

Thanks in advance ,

Hirish

Re: Final Total Caluculation

preminqlik — Thu, 05 Nov 2015 09:50:43 GMT

what you req exactly can you make output excel and send for your application pivot table

Re: Final Total Caluculation

Anonymous — Thu, 05 Nov 2015 10:05:01 GMT

What exactly you want?

As per your logic Clp* Performance, it is giving you right data.

Nothing wrong in it.

Re: Final Total Caluculation

HirisH_V7 — Thu, 05 Nov 2015 10:14:56 GMT

Hi,

In the application i want to have when i select two states the Grandtotal performance should be Like this,

as attached in the excel sheet.

89.55

Thanks for your response,

Hirish

Re: Final Total Caluculation

Anonymous — Thu, 05 Nov 2015 10:31:54 GMT

IS this?

PFA..

Re: Final Total Caluculation

Kushal_Chawda — Thu, 05 Nov 2015 10:33:35 GMT

Please see the attached

Re: Final Total Caluculation

HirisH_V7 — Thu, 05 Nov 2015 11:03:25 GMT

No, If i select M1 and M2 it should be Finla performance grand total should be 89.5

Thanks,

hirish

Re: Final Total Caluculation

vipin_mishra479 — Thu, 05 Nov 2015 11:54:43 GMT

Please check this may be help full

Re: Final Total Caluculation

HirisH_V7 — Thu, 12 Nov 2015 08:45:02 GMT

Hi vipin.mishra479,

Please check the attachment . i made a Change in dimension. Help out . how to create final performance.

Thanks,

hirish