Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
ankit777
Valued Contributor

Script help

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.

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Script help

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;

2 Replies
MVP
MVP

Re: Script help

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;

ankit777
Valued Contributor

Re: Script help

Thanks Manish

Community Browser