Straight Table Issue

[#1]

Hi Experts

I  have a following Script

COMPB:

LOAD

    [Level 1 Names],

    [Level 2 Names] AS [COMPB Level 2 Names],

    [COMPB Level 3],

    [Level 3 Names] AS [COMPB Level 3 Names],

    [COMPB Level 4 Names],

    [COMPB X-ref 1],

    [COMPB Sales]

FROM

[COMPB INC PURCHASE (ML REVIEW 25 06).xlsx]

(ooxml, embedded labels, table is [COMPB Table ]);

JOIN

LOAD [Supplier Ref] as [COMPB Supplier],

    [Supplier Name] as [COMPB Supplier Name],

    [COMPB BRAND],

    [Level 1 Names] ,

    [Level 2 Names] AS [COMPB Level 2 Names],

    [COMPB Level 3],

    [Level 3 Names]  AS [COMPB Level 3 Names],

    [X-REF1] AS [COMPB X-ref 1]

FROM

[COMPB INC PURCHASE (ML REVIEW 25 06).xlsx]

(ooxml, embedded labels, table is [COMPB Supplier ]);

JOIN

COMPB_List:

LOAD

  [COMPB Level 3],

        [Senior Buyer]

FROM

[COMPB INC PURCHASE (ML REVIEW 25 06).xlsx]

(ooxml, embedded labels, table is [PM List ]);

COMPA:

LOAD [Level 1 Names],

    [Level 2 Names] AS [COMPA Level 2 Names] ,

    [COMPA Level 3],

    [Level 3 Names] AS [COMPA Level 3 Names],

    [COMPA Level 4 Names],

    [COMPA X-ref 1],

    [COMPA sales]

FROM

[COMPB INC PURCHASE (ML REVIEW 25 06).xlsx]

(ooxml, embedded labels, table is [COMPA Table ]);

JOIN

LOAD [Supplier Ref] as [COMPA Supplier],

    [Supplier Name]  as [COMPA Supplier Name],

    [Level 1 Names],

    [Level 2 Names] AS [COMPA Level 2 Names],

    [COMPA Level 3],

    [Level 3 Names]  AS [COMPA Level 3 Names],

    [COMPA X-ref 1]

FROM

[COMPB INC PURCHASE (ML REVIEW 25 06).xlsx]

(ooxml, embedded labels, table is [COMPA Supplier ]);

JOIN

COMPA_List:

LOAD

    [COMPA Level 3],

    [Buyer]

FROM

[COMPB INC PURCHASE (ML REVIEW 25 06).xlsx]

(ooxml, embedded labels, table is [PM List ]);

Now I am using [COMPA Level 2 Names] ,],  in a list box, all  the values are coming exactly as in Excel Data 

but when I use this in a Straight  Table some Values for [COMPA Level 2 Names] , are missing 

when I use table box, all the values are generating as expected

What Might be the issue in Straight Table

Please Suggest

[swuehl]

You are using the field in a straight table with which expressions?

Have you disabled the 'suppress zero values' on presentation tab and check also the 'Show all' options on dimension tab?

Could you upload a small sample QVW that demonstrates your issue?

[#3]

What is the expressions and other dimensions you are using in the straight table?

[perla_chirag]

Hi John,

What expression are you using for the Straight chart?

[#5]

If all the expressions have 0 as value, then the rows will not be populated in straight table. To check this, uncheck the "Supress Zero Values" in Presenation tab.

[#6]

HI

I am using

[COMPA Level 2 Names]

[COMPA Level 3 Names]

[COMPA Level 4 Names]

as my dimensions and Just Sum([COMPA sales]) in Expresions

i tried checking  Show All Values and Supress When values Null 

but no changes