All rows are not coming in table box

[ngreddy1982]

Hi,

I have sql select statement where i have joined 3 tables with inner join then I opened qlik view , done connection from same databasr , pasted my select satae ment , it is fetching 264 lines . I have prepared table box it is showing only 15 rows insted of 264 rows. how can I show all rows ??

Please help.

[sunny_talwar]

Table box only shows the distinct combination of added field.... to see all the unique fields, may be add RecNo() as Key and then add this to your table box

[yoganantha321]

Hi Giridhar,

As sunny mentioned table box shows only distinct values. If requirement permits you can show it in straight table or pivot table.

[ngreddy1982]

I have used straight table , it says no data to present.

[Peter_Cammaert]

You'll have to add at least one expression. Even a dummy one like =1 (and then hide that column) may help you out.

[ngreddy1982]

This is my load statement, is there anything I have to use? i have made connection and copy pasted query which is working perfect from sql

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='£#,##0.00;-£#,##0.00';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

SET FirstWeekDay=0;

SET BrokenWeeks=1;

SET ReferenceDay=0;

SET FirstMonthOfYear=1;

SET CollationLocale='en-GB';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=TBW_BI;Data Source=FU-FS-BISQL01;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=LON-OPS-SPARE;Use Encryption for Data=False;Tag with column collation when possible=False];

SELECT 

        CO.[Actual Packaging],

     IT.[Description],

     [Reason Code]='RTN_DAMAGE',

     [Internet Order No_],

  [Country],

  [Order Date],

  CO.[Shipping Agent Code],

  [Gross Weight]

  FROM [TBW_BI].[dbo].[Dreams$Consignment] AS CO

  INNER JOIN [TBW_BI].[dbo].[Dreams$Item] AS IT

  ON CO.[Actual Packaging]=IT.[No_]

  INNER JOIN [TBW_BI].[dbo].[Dreams$Warehouse Returns] AS RE

  ON RE.[Item No_]=IT.[No_]

  INNER JOIN [TBW_BI].[dbo].[Dreams$Internet Order Header] AS HE

  ON HE.[Order Guid]=RE. [Internet Order No_]

   WHERE

    [order date] >= '2017-01-01T00:00:00.000' AND

    [order date] <= '2017-01-31T00:00:00.000'

[sunny_talwar · Accepted solution]

1) Are you using Straight table or table box?

2) Are you using any expression or all dimensions?

3) Do you uncheck 'Suppress Zero Values' on the presentation tab?

[ngreddy1982]

Hi I am using straight table, used a dummy  expression and disabled it .

[sunny_talwar]

instead of disabling it, hide it from the presentation tab and see if that works