Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
jpipalia
Contributor
Contributor

Adding up Values from a Straight Table

Hi,

I'd like to know how to do the following process. I have a straight table so far that looks like this.

TeamValue
A20
A40
A10
B10
B30
C40
C10

The values come from an expression which uses if, aggr and sum functions. I would like to produce a new table which adds up the value for each team. So we can end up with something like this.

TeamTotal Value
A70
B40
C50

It would be much appreciated if someone can help.

Cheers

9 Replies
Anil_Babu_Samineni

Try this?

Table:

Load Team, Value From Table;

T2:

NoConcatenate

Load Team, Sum(Value) as Value Resident Table Group By Team;

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
jpipalia
Contributor
Contributor
Author

Hi,

Silly question but would you write something like this in the script of Qlikview? I have normally been using the 'New Sheet Object' option to create tables.

Cheers

sibin_jacob
Creator III
Creator III

It will be good, if you can share the sample application or the dimension and expression to understand the requirement clearly.

balabhaskarqlik

Try like this:

Chart - Straight table

Dim - Team

Expression - Aggr(Sum(Value),Team)

jpipalia
Contributor
Contributor
Author

Perhaps it's easier if I explain more thoroughly how the values are obtained.

So we have ValuesA for each player in each team. I.e. something like,

Team --- Player -- ValuesA

A               1               4

A               2               8

A               3               1

B               8               7

Now in the table I have described in the original post, the values are obtained by the following.

If ValuesA for each player < A limit I have set, then return the ValuesA. Else, give me the limit.

So if this limit was 6, then for the main table we would get the following:

Team ---- Value

A               4

A               6

A               1

B               6

And from this table, I would like to do the following (add up value for each team):

Team -----  Value

A                    11

B                    6

haneeshmarella
Creator II
Creator II

Try this for expression in new table with dimension as Team:

sum(aggr(value,team))

vishsaggi
Champion III
Champion III

Can you share the actual expression your Value field is generated?

vishsaggi
Champion III
Champion III

Based on below sample can you elaborate what you mean by limit?

Team --- Player -- ValuesA

A              1              4

A              2              8

A              3              1

B              8              7


If ValuesA for each player < A limit I have set, then return the ValuesA. Else, give me the limit. ->


Quite did not understand what you mean highlighted above. Can you elaborate please.

Anil_Babu_Samineni

The script already in place. If you want in UI you can do following steps.


Create Straight table

Dimension - Team

Measure    - Sum(Value)

This information enough to get same answer. IF your question got answer we recommend you to close this thread by flag "Correct answer" and helpful for other which is useful for you

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)