topic Re: All rows are not coming in table box in QlikView

All rows are not coming in table box

ngreddy1982 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: All rows are not coming in table box

sunny_talwar — Tue, 28 Mar 2017 11:39:34 GMT

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

Re: All rows are not coming in table box

yoganantha321 — Tue, 28 Mar 2017 12:11:18 GMT

Hi Giridhar,

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

Re: All rows are not coming in table box

ngreddy1982 — Tue, 28 Mar 2017 12:51:45 GMT

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

Re: All rows are not coming in table box

Peter_Cammaert — Tue, 28 Mar 2017 12:54:06 GMT

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

Re: All rows are not coming in table box

ngreddy1982 — Tue, 28 Mar 2017 12:54:43 GMT

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'

Re: All rows are not coming in table box

sunny_talwar — Tue, 28 Mar 2017 13:29:29 GMT

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?

Re: All rows are not coming in table box

ngreddy1982 — Tue, 28 Mar 2017 13:32:37 GMT

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

Re: All rows are not coming in table box

sunny_talwar — Tue, 28 Mar 2017 13:34:19 GMT

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