Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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;

9 Replies
hector_munoz
Specialist
Specialist

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

swuehl
MVP
MVP

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

Anonymous
Not applicable
Author

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..?

Anonymous
Not applicable
Author

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

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

Anonymous
Not applicable
Author

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

sunny_talwar

‌you need semi Colon after Resident A;

Anonymous
Not applicable
Author

Thanku Sunny....

Now it is working

sunny_talwar

‌Awesome