Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Table box help

Hi exports,

I have a table box(all are direct values ,we do not use any caculations) with below values.My issue is I am getting two rows for each Order Line item but I need only one row which will have standard cost value.

Here is the IN put table:

Effective DateBusiness SegmentPoleOrder NumberOrder Type(SO/PO)Order Line ItemDelivery PriorityStandard Cost - USD
9/4/2014Critical PowerEMEA0150012011SO00001002
9/4/2014Critical PowerEMEA0150012011SO0000100211.64000
9/4/2014Critical PowerEMEA0150012011SO00002002
9/4/2014Critical PowerEMEA0150012011SO0000200211.64000
9/4/2014Critical PowerEMEA0150012011SO00003002
9/4/2014Critical PowerEMEA0150012011SO0000300213278.57000

I need OUTPUT like

Effective DateBusiness SegmentPoleOrder NumberOrder Type(SO/PO)Order Line ItemDelivery PriorityStandard Cost - USD
9/4/2014Critical PowerEMEA0150012011SO0000100211.64000
9/4/2014Critical PowerEMEA0150012011SO0000200211.64000
9/4/2014Critical PowerEMEA0150012011SO0000300213278.57000

any suggestions ,

Thanks

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Solution 1: load only the records where Standard Cost - USD has a value:

LOAD * FROM ...somewhere... WHERE len(trim([Standard Cost - USD])) > 0;

Solution 2: Add a listbox for the [Standard Cost - USD] field and select all values in it.

Solution 3: Use a straight table instead of a table box and add an expression only({<[Standard Cost - USD]={'*'}>}1), then hide the expression on the Presentation tab.


talk is cheap, supply exceeds demand

View solution in original post

6 Replies
Gysbert_Wassenaar

Solution 1: load only the records where Standard Cost - USD has a value:

LOAD * FROM ...somewhere... WHERE len(trim([Standard Cost - USD])) > 0;

Solution 2: Add a listbox for the [Standard Cost - USD] field and select all values in it.

Solution 3: Use a straight table instead of a table box and add an expression only({<[Standard Cost - USD]={'*'}>}1), then hide the expression on the Presentation tab.


talk is cheap, supply exceeds demand

View solution in original post

ashfaq_haseeb

May be you need to format date as below while loading it from database.

Date(Floor(Date_Time)) as Date,

Regards

ASHFAQ

Not applicable
Author

Thanku Gysbert for your quick reply.
I have tried your 3rd solution but not yet resolved the issue.

I am sharing my sample app pls look into it .

Thanks

ashfaq_haseeb

Hi,

use this expression.

only({<[Standard Cost - USD]={'*'}-{''}>}1)

have a look at attached application

Regards

ASHFAQ

Not applicable
Author

Thanks Ashfaq, your solution looks good for staright table but do we have any more possible solution in table box,because my client wants me to do it in table box.

Thanks


bill_markham

On the Table Box, Properties, Presentation :

  • Select Standard Cost - US
  • Tick <Omit Rows Where Field is NULL>

If the blank Standard Cost - US values are not null, then force then to Null in the load script :

     if ( [Standard Cost - USD] > 0 , [Standard Cost - USD] ) as [Standard Cost - USD]