Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

gulshanrohilla
Contributor

can anyone tell me the flow of execution in the below case

A:

Load * Inline [

A, B, C, Sum

1, P, B, 500

1, P, 4, 600

2, S, 5, 700

3, R, 6, 800

];

B:

Load A,

     B,

     Sum(Sum) As total

     resident A

     Group By A,B;

     Drop Table A;

Tags (1)
9 Replies
hector_munoz_in
Valued Contributor

Re: can anyone tell me the flow of execution in the below case

Hi Gulshan,

  1. You create 'A' inline table (with manual entry of information) with 'A', 'B' and 'C' as dimension fields and 'Sum' as an expression field.
  2. You create 'B' table from resident table 'A' with dimension fields 'A' and 'B' and an aggregated expresion field 'total' result of the sum of 'Sum' expression field. This aggregation is made from 'A' and 'B' fields.
  3. You drop 'A' table as it is not needed furthermore.

Is this what you needed?

Regards,

H

MVP
MVP

Re: can anyone tell me the flow of execution in the below case

1) Table A will be loaded, source is an INLINE table

2) Table B will be loaded, source is the resident table A from the data model

while loading table B, the records will be grouped by fields A and B and an aggregate will be calculated.

3) Table A will be dropped from the model

gulshanrohilla
Contributor

Re: can anyone tell me the flow of execution in the below case

Hi Hector,

Actually I just want to know that When Execution flow reaches in table B the first statement that will execute is resident. after that which Statement will execute and why..?

gulshanrohilla
Contributor

Re: can anyone tell me the flow of execution in the below case

Hi Stefan,

Thanks for your information. It helps me a lot. can you please tell me that when I comment the Group by statement then in Drop statement it'll give error. why is it so..?

hector_munoz_in
Valued Contributor

Re: can anyone tell me the flow of execution in the below case

Gulshan,

I suposse that is not DROP TABLE sentence what fails; if you comment GROUP BY sentence you cannot use Sum() function (or another aggregation function).

Regards,
H

gulshanrohilla
Contributor

Re: can anyone tell me the flow of execution in the below case

But again it gives an error...error.PNG

Re: can anyone tell me the flow of execution in the below case

‌you need semi Colon after Resident A;

gulshanrohilla
Contributor

Re: can anyone tell me the flow of execution in the below case

Thanku Sunny....

Now it is working

Re: can anyone tell me the flow of execution in the below case

‌Awesome  

Community Browser