Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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).