topic Sum(Total) pivot table issue in QlikView

Sum(Total) pivot table issue

gr_eldred — Thu, 26 Jul 2018 22:49:57 GMT

I need help with this operation

Sales / Total Sales

Example

W27 Sales / Total Sales

=num(

sum({$<Status-={'C'}, art_status={'L'}, Clasificación ={'Accesorios de Terceros','Accesorios de terceros'}, [Año Apple]={$(V_Año_Actual)}>} Cantidad_I)

sum( total {$<Status-={'C'}, art_status={'L'}, Clasificación ={'Accesorios de Terceros','Accesorios de terceros'}, [Año Apple]={$(V_Año_Actual)}>} Cantidad_I)

,'#,##0.00%')

can you help me Please!!

Re: Sum(Total) pivot table issue

petter — Fri, 27 Jul 2018 06:35:13 GMT

Hi Eldred,

So what exactly is your problem? Doesn't it calculate the expression you showed us?

If you have some raw data or a sample application that would be very helpful to be able to get you feedback quickly...

Re: Sum(Total) pivot table issue

ogautier62 — Fri, 27 Jul 2018 06:35:14 GMT

Hi,

what does not work ?

have you got "expression OK" or not ,

what is your result ?

regards

Re: Sum(Total) pivot table issue

raviityou — Fri, 27 Jul 2018 06:59:33 GMT

share sample .qvw and expected result.

Re: Sum(Total) pivot table issue

BalaBhaskar_Qlik — Fri, 27 Jul 2018 09:50:49 GMT

In Pivot table, Do you want to calculate the Percentage of W27 on Totals?

Re: Sum(Total) pivot table issue

BalaBhaskar_Qlik — Fri, 27 Jul 2018 09:57:16 GMT

Can it be:

=num(

sum({$<Status-={'C'}, art_status={'L'}, Clasificación ={'Accesorios de Terceros','Accesorios de terceros'}, [Año Apple]={$(V_Año_Actual)}>} Cantidad_I)

Aggr(NODISTINCT sum( total {$<Status-={'C'}, art_status={'L'}, Clasificación ={'Accesorios de Terceros','Accesorios de terceros'}, [Año Apple]={$(V_Año_Actual)}>} Cantidad_I), FieldName(art_Status))

,'#,##0.00%')

Re: Sum(Total) pivot table issue

neelamsaroha157 — Fri, 27 Jul 2018 19:05:21 GMT

=num(

sum({$<Status-={'C'}, art_status={'L'}, Clasificación ={'Accesorios de Terceros','Accesorios de terceros'}, [Año Apple]={$(V_Año_Actual)}>} Cantidad_I)

sum( total <Marca> {$<Status-={'C'}, art_status={'L'}, Clasificación ={'Accesorios de Terceros','Accesorios de terceros'}, [Año Apple]={$(V_Año_Actual)}>} Cantidad_I)

,'#,##0.00%')

Re: Sum(Total) pivot table issue

gr_eldred — Fri, 27 Jul 2018 20:24:33 GMT

Is Correct Thank you very Much!! @Neelam Sehrawat

Re: Sum(Total) pivot table issue

neelamsaroha157 — Fri, 27 Jul 2018 20:30:04 GMT

I am glad it worked . Please close the thread.