Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
pratik_advani
Contributor
Contributor

Dimensionless Straight Table

Hi, Can any one tell me how to display straight table with one of its column as a KPI and the following columns displays its measures.

Eg. 1st column-Total Sales Volume(as rows) as a KPI(column header), 2nd Column-Previous Year's Sales(column header) as a measure(as rows), 3rd column-Current Year Sales(column header) as a measure(as rows).

2 Replies
Not applicable

Try using Pivot table instead.

It is achievable, share some sample qvw, if possible.

MK_QSL
MVP
MVP

Create a Straight Table

Dimension = No Dimension

Expressions

SUM(Amount)

SUM({<Year = {'$(=Max(Year)-1)'}>}Amount)

SUM({<Year = {'$(=Max(Year))'}>}Amount)