topic Straight Table Issue in QlikView

Straight Table Issue

Thu, 02 Jul 2015 12:54:02 GMT

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

Re: Straight Table Issue

swuehl — Thu, 02 Jul 2015 12:57:27 GMT

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?

Re: Straight Table Issue

Thu, 02 Jul 2015 12:57:55 GMT

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

Re: Straight Table Issue

perla_chirag — Thu, 02 Jul 2015 12:58:34 GMT

Hi John,

What expression are you using for the Straight chart?

Re: Straight Table Issue

Thu, 02 Jul 2015 12:59:24 GMT

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.

Re: Straight Table Issue

Thu, 02 Jul 2015 14:04:34 GMT

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