topic Re: Re: Dimensions and Expressions in QlikView

Dimensions and Expressions

Tue, 01 Apr 2014 11:31:04 GMT

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

Re: Dimensions and Expressions

MK_QSL — Tue, 01 Apr 2014 11:34:29 GMT

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)

Re: Dimensions and Expressions

its_anandrjs — Tue, 01 Apr 2014 11:38:39 GMT

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

Hope this helps

Re: Dimensions and Expressions

its_anandrjs — Tue, 01 Apr 2014 12:21:13 GMT

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

Re: Re: Dimensions and Expressions

Tue, 01 Apr 2014 13:07:18 GMT

Here are the results, I am doing something wrong

Re: Re: Dimensions and Expressions

its_anandrjs — Tue, 01 Apr 2014 13:13:02 GMT

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

Re: Dimensions and Expressions

Tue, 01 Apr 2014 13:15:52 GMT

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>

Re: Dimensions and Expressions

Tue, 01 Apr 2014 14:25:29 GMT

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>