topic Re: Dimensionless Straight Table in QlikView

Dimensionless Straight Table

Anonymous — Thu, 25 Sep 2014 09:12:20 GMT

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).

Re: Dimensionless Straight Table

Thu, 25 Sep 2014 09:16:40 GMT

Try using Pivot table instead.

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

Re: Dimensionless Straight Table

MK_QSL — Thu, 25 Sep 2014 09:17:16 GMT

Create a Straight Table

Dimension = No Dimension

Expressions

SUM(Amount)

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

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