Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dimensions and Expressions

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

1 Solution

Accepted Solutions
its_anandrjs
Champion III
Champion III

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

View solution in original post

7 Replies
MK_QSL
MVP
MVP

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
Champion III
Champion III

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

Hope this helps

its_anandrjs
Champion III
Champion III

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

Not applicable
Author

Here are the results, I am doing something wrong

its_anandrjs
Champion III
Champion III

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

Not applicable
Author

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>

Not applicable
Author

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>