Skip to main content
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