Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Sub Total Column and Place another column as shown below

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?

 

2020-07-16_14-34-25.jpg

Neves
1 Solution

Accepted Solutions
Highlighted

For your sample below would work

Sum(Total<DT> VENDAS)

 image.png

View solution in original post

5 Replies
Highlighted

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

 

Highlighted
Specialist
Specialist

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

];

2020-07-16_15-30-00.jpg

Neves
Highlighted
Specialist
Specialist

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))

 

 

Neves
Highlighted

For your sample below would work

Sum(Total<DT> VENDAS)

 image.png

View solution in original post

Highlighted
Specialist
Specialist

Tranks Sanny😁

Neves