Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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)