Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

Re: How to Structure this table

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes