Can a straight table have one dimension in column and one dimension in row?

[#1]

Hi All

I was wondering, if there's a way in qlikview to create a straight table with one dimension as column and one as row and the expression will evaluate to the cell value.

Something like below:-

[PrashantSangle]

Hi,

This is possible Pivot table not straight table

Regards

[tresesco · Accepted solution]

You can:

with straight table -> Dimension: Year, seperate expression for every country like: Sum({<Country={'US'>} Sales), ...

with pivot (easier and ideal)-> Dim1: Year, Dim2: Country, Exp: Sum(Sales),,,,, then drag the second dimension to the top to form the row.

[#4]

In the standard scenario it is not feasible, but we implemented this if your labels are static.

For 2011,1 formula where country ={US,Canada,Spain,Mexico}

For 2012,2nd formula where country ={US,Canada,Spain,Mexico}

For 2013,3rd formula where country ={US,Canada,Spain,Mexico}

For 2014,4th Formula where country ={US,Canada,Spain,Mexico}

All these in presentation tab

mark as horizontal.

Hope it Helps.

[#5]

Thanks.

Got it working with the pivot table.