topic Re: Sub Total Column and Place another column as shown below in QlikView

Sub Total Column and Place another column as shown below

Ribeiro — Thu, 16 Jul 2020 17:38:57 GMT

I need to bring the subtotal value of each dimension in the total store column. as set analysis below.

STORE:

sum({$<[EFETIVADA]={'1'},[CANCELADA]={'0'},[EVENDA]={'1'},[TIPOSAIDAENTRADA]={'S'}>}VALORTOTAL)

-
IF(sum({$<[EFETIVADA]={'1'},[CANCELADA]={'0'},[EVENDA]={'1'},[TIPOSAIDAENTRADA]={'S'}>}VALORTOTAL),
SUM(TOTALDEV))

STORE TOTAL?

Re: Sub Total Column and Place another column as shown below

sunny_talwar — Thu, 16 Jul 2020 19:01:37 GMT

What is your chart dimension in this chart? Also, make sure to list them in the order of when try appear in the chart

Re: Sub Total Column and Place another column as shown below

Ribeiro — Thu, 16 Jul 2020 19:14:02 GMT

I need the subtotal according to the image

LOJA, VENDAS, SUBTOTAL_VENDAS, TOTAL GERAL, DT,
A, 20, 30, 160, 15/01/2020
A, 10, 30, 160, 15/01/2020
B, 20, 70, 160, 18/01/2020
B, 40, 70, 160, 18/01/2020
B, 10, 70, 160, 18/01/2020
C, 50, 60, 160, 19/01/2020
C, 10, 60, 160, 19/01/2020

];

Re: Sub Total Column and Place another column as shown below

Ribeiro — Thu, 16 Jul 2020 19:16:31 GMT

To pass to expression below the dimension is the same of the attached qvw.

soma ({$ <[EFETIVADA] = {'1'}, [CANCELADA] = {'0'}, [EVENDA] = {'1'}, [TIPOSAIDAENTRADA] = {'S'}>} VALORTOTAL)

-
SE (soma ({$ <[EFETIVADA] = {'1'}, [CANCELADA] = {'0'}, [EVENDA] = {'1'}, [TIPOSAIDAENTRADA] = {'S'}>} VALORTOTAL ),
SUM (TOTALDEV))

Re: Sub Total Column and Place another column as shown below

sunny_talwar — Thu, 16 Jul 2020 19:38:57 GMT

For your sample below would work

Sum(Total<DT> VENDAS)

Re: Sub Total Column and Place another column as shown below

Ribeiro — Thu, 16 Jul 2020 19:50:01 GMT

Tranks Sanny😁