Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
What is the expressions and other dimensions you are using in the straight table?
Hi John,
What expression are you using for the Straight chart?
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.
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