topic Re: Script help in QlikView

Script help

ankit777 — Fri, 12 Dec 2014 09:50:46 GMT

Hi All,

Suppose I have a table like below.

Id, Marks

1,10

2,34

3,21

4,56

5,11

I want to draw a chart in which dimension will be id and expression will be sum(Marks)

I want to overide the id , show same values of sum corresponding to all Id. ie, in chart it should show 132 corresponding to all id's.

Please help how the expression needs to be changed.

Re: Script help

MK_QSL — Fri, 12 Dec 2014 09:56:50 GMT

Expression

SUM(TOTAL Marks)

Or

You can get the same by script

Table1:

Load * Inline

[

Id, Marks

1,10

2,34

3,21

4,56

5,11

];

Left Join

Load SUM(Marks) as TotalMarks Resident Table1;

Re: Script help

ankit777 — Fri, 12 Dec 2014 10:16:12 GMT

Thanks Manish