Show Qlikview Straight table Sum without merging dimension if it is duplicate.

[aghabdurauf_Badri]

Records/Values in the database might be like this:

User ID          Date               Minutes     Uploaded

123               12/13/2013      50               12/14/2013

123               12/13/2013      50               12/15/2013

When I sum the minutes in the straight table the result shows like this

QlikView Straight Chart shows this

User ID                         Minutes

123                                100

but I want the result like this

User ID          Minutes

123                  50 

123                  50 

What should I try to show table like this

[stevejoyce]

You'll need a unique identifier in the table to split these records in data model & straight table.  If you dont have in the data model already, you can add one using RowNo() as YourKey.

Your front-end table will need to have this as a dimension.  Since you are in QlikView, you can add this as a dimension and then Hide this column in the Presentation tab. 

Otherwise you would either need

a) always show the column

OR

b) you can have your User ID field be Dual([User ID], YourKey).