topic Re: sum for cyclic group in QlikView

sum for cyclic group

prma7799 — Tue, 23 Jun 2015 11:45:33 GMT

Dear All ,

I have one pivot table with cyclic group dimension.

I want each dimension wise total which is present in cyclic group .

thanks

Re: sum for cyclic group

MK_QSL — Tue, 23 Jun 2015 11:52:59 GMT

can you please provide little more information on your requirements?

Re: sum for cyclic group

prma7799 — Tue, 23 Jun 2015 11:59:36 GMT

Hi Manish,

I have one pivot table in that i applied cyclic group in cyclic group i used two dimension say brand and product .

My question is can it is possible to do partial sum on both dimension . because i did partial sum on group but it not showing me sum on brand wise and product wise it will show group wise partial some.

Please tell me if it is possible in Pivot or straight table.

Thanks

Re: sum for cyclic group

buzzy996 — Tue, 23 Jun 2015 12:11:22 GMT

i think tis helps.

Re: sum for cyclic group

prma7799 — Tue, 23 Jun 2015 12:19:26 GMT

Hi shiva,

I already did that one , I think it is showing name wise sum not serialID wise.

Am i right ?

Thanks

Re: sum for cyclic group

buzzy996 — Tue, 23 Jun 2015 12:23:41 GMT

it's calculating the combination of both (serial id and name)

Re: sum for cyclic group

prma7799 — Tue, 23 Jun 2015 12:30:56 GMT

I want division wise and serialid wise sum

Re: sum for cyclic group

buzzy996 — Tue, 23 Jun 2015 12:36:32 GMT

if so..try ,add serial id as dimension and select check box "partial sum" on same field !