Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Horizontal dimension in straight table

I have created a straight table. I am using two dimensions in the table. It is resulting in one row for each dim1 dim2 combination.


For eg, If my first dimension is X (which contains a,b,c), and the second is Y (which contains 1,2,3), I am getting a table as follows


a     1     ................

a     2     ................

a     3     .................

b     1     ................

b     2     ..................

b     3     ...............

c     1     ..............

c     2     ...............

c     3     .................


I would like to see my result in the following form:


           1     2     3   

a          ..     ..     ..

b          ..     ..     ..

c          ..     ..     ..


Can somebody plz tell me if I can do this without using a pivot table? I also don't want to use separate expressions for each value of Y. Thanks

6 Replies
its_anandrjs

Update new

As you say without pivot and do not want to write many expression then you have to use only pivot from my suggestion see when your value increase in the Y dimension then you have to write more expressions which need to avoid. You can use pivot table for this and then select Y dimension and drag it towards the right upper corner then you see the blue arrow mark when it is convert into horizontal leave your dimension there.

See the snap some thing like below image

Pivott.png

swuehl
MVP
MVP

Without using a pivot table?

Hm, You can create several expressions instead the second dimension, one expression for each dimension value (needs manual maintenance), limiting the records to the fields values '1','2','3' withing the expression (using if() statement or set analysis).

edit: I've overseen your last sentence. No, I don't think it's possible then.

MK_QSL
MVP
MVP

Either

     Use Pivot Table

or

     use Straight Table with Several Expressions and using if or set analysis

its_anandrjs

Yes Swuehl is write you have to write many expression for every condition in SET of if condition like

Dimenion:- X

Expr1:-sum({<Y={'1'} >} sales)

Expr2:-sum({<Y={'2'} >} sales)

Expr3:-sum({<Y={'3'} >} sales)

If you use Pivot and straight see the snap for difference

Straight &amp; Pivot.png

MK_QSL
MVP
MVP

Like this ?

Not applicable
Author

Hi,

Create the same in Pivot chart with 2 dimensions.

Darg the 2 nd dimension to top.

Hope this is helpful.

Regards,

Joshmi