topic Expression Wants Between Dimensions in QlikView

Expression Wants Between Dimensions

Tue, 09 Aug 2011 12:01:04 GMT

I have table containing below columns.. (FYI... Orders recevied from our customers sent for execution to our supplier, we are working as an intermediate)

Customer Name

Customer ID

Customer Order Number

Customer Part Number

Order Quantity

Order Price

Supplier ID

Supplier Part Number

Supplier Price

I want final table with Customer Order Total (=Order Quantity * Order Price) after Order Price column and Supplier Order Total (=Order Quantity * Supplier Price) as a last column.

Please help....!!!

Expression Wants Between Dimensions

its_anandrjs — Tue, 09 Aug 2011 12:38:44 GMT

Hi mrkachhia,

You need to write some thing like this in your script.

Customer Name

Customer ID

Customer Order Number

Customer Part Number

Order Quantity

Order Price

(Order Quantity * Order Price) as CustomerOrderTotal

Supplier ID

Supplier Part Number

Supplier Price

(Order Quantity * Supplier Price) as SupplierOrderTotal

As i understand it am i right or wrong please confirm.

Regards,

Anand

Expression Wants Between Dimensions

Tue, 09 Aug 2011 12:46:09 GMT

I have done this but not able to fixed value of these two columns to 2 decimal...

Expression Wants Between Dimensions

Tue, 09 Aug 2011 12:49:50 GMT

Go to settings, document properties, numbers.

Select the fields you want fixed and change the number settings.

Expression Wants Between Dimensions

its_anandrjs — Tue, 09 Aug 2011 12:54:26 GMT

Hi,

You need to set its decimal place by change the setting of this column. Just go to Properties->Number->select the

column->Fixed to select decimal place 2 and then change it.

Hope this helps you.

Regards,

Anand

Re: Expression Wants Between Dimensions

Tue, 09 Aug 2011 13:31:26 GMT

Thanks to both of you....its working, can i get total of all line at bottom or top for both of these columns?

Expression Wants Between Dimensions

its_anandrjs — Tue, 09 Aug 2011 13:43:37 GMT

Hi,

Yes you need to select the Straight Table go to Presentation-> and select Totals on first row.

Regards,

Anand

Re: Expression Wants Between Dimensions

Tue, 09 Aug 2011 14:02:58 GMT

total on first row works only for EXPRESSIONs and not for DIMENSIONs.

Am i RIGHT?

Re: Expression Wants Between Dimensions

its_anandrjs — Tue, 09 Aug 2011 14:06:15 GMT

Hi,

Yes you right it works only for Expressions.

Anand

Re: Expression Wants Between Dimensions

Tue, 09 Aug 2011 14:12:10 GMT

OK THANKS....