Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikofba
Contributor II
Contributor II

How to Structure this table

If I have a table below

SaleID, Amount

1,500

2,300

3,5000

4,3000

5,1000

I want it displayed like this

Key,Value

Sales ,5

Total Sales,10000

Average Sale, 2000

 

I am struggling putting the key value in the table.  I have researched pivot tables but I don't think this would be resolved with that.

Thanks,

1 Reply
Vegar
MVP
MVP

You could do it with a straight table using no dimensions and three measures with no total aggregations. See picture below. I'll also attach a qvw file for reference.

image.png