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

Expression Wants Between Dimensions

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....!!!

1 Solution

Accepted Solutions
its_anandrjs

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

View solution in original post

9 Replies
its_anandrjs

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

Not applicable
Author

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

Not applicable
Author

Go to settings, document properties, numbers.

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

its_anandrjs

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

Not applicable
Author

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

its_anandrjs

Hi,

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

Regards,

Anand

Not applicable
Author

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

Am i RIGHT?

its_anandrjs

Hi,

Yes you right it works only for Expressions.

Anand

Not applicable
Author

OK THANKS....