Dimensions and Expressions

[#1]

Hello,

I would like to know if in the file attached where I have TABLE1 that is a QVD , I can créate a document with TABLE2 structure.

Thanks a lot

[MK_QSL]

Script..

Load * Inline

[

SKN, LOCNO, Pieces

15164, 3802, 1

15164, 3824, 2

18104, 3821, 2

18104, 3828, 1

18104, 3904, 2

];

Now create a pivot table

Dimension

SKN

LOCNO

Expression

SUM(Pieces)

[its_anandrjs]

You have to load data cross table other wise you an do this with pivot table

Hope this helps

[its_anandrjs · Accepted solution]

Take a pivot table and in

Dimension1 -> SKN

Dimension2 -> LOCNO

Expression -> Pieces

And drag the Pieces field last to the upper corner of chart

Hope this helps

[#5]

Here are the results, I am doing something wrong

[its_anandrjs]

Right click on chart and Expand All - then click on LOCNO dimension and drag then you get a blue arrow then drag it to upper right corner of the chart.

Thanks & Regards

[#7]

Yes, is fine. Thanks a lot for your help.

Regards

De: Anand Chauhan

Enviado el: martes, 01 de abril de 2014 15:14

Para: Salmerón, Joaquín

Asunto: Re: - Re: Dimensions and Expressions

Qlik Community<http://community.qlik.com/>

Re: Dimensions and Expressions

reply from Anand Chauhan<http://community.qlik.com/people/its.anandrjs?et=watches.email.thread> in App Development - View the full discussion<http://community.qlik.com/message/499832?et=watches.email.thread#499832>

[#8]

Thanks a lot Manish.

Best Regards

De: Manish Kachhia

Enviado el: martes, 01 de abril de 2014 13:35

Para: Salmerón, Joaquín

Asunto: Re: - Dimensions and Expressions

Qlik Community<http://community.qlik.com/>

Dimensions and Expressions

reply from Manish Kachhia<http://community.qlik.com/people/MRKachhiaIMP?et=watches.email.thread> in App Development - View the full discussion<http://community.qlik.com/message/499699?et=watches.email.thread#499699>