How to make Qlik Sense table display all rows

[wanyunyang]

I'm trying to display selling information for each customer, with each customer hundreds of rows. But straight table is not displaying everything for a customer, unless I click on that customer.

I think that is because my data scale is too large. Is there a way to display everything without clicking on one customer?

[ArnadoSandoval]

Hi Wanyun,

I am trying to understand the requirement you are trying to implement, basically you want to display all the sales transactions for all your customers in the back-end database; Straight Table should be able to do it, but, I am wondering why? QlikSense is the perfect tool to dice-slice information, but dump all the back-end data at once could be challenging; you could be talking about 1,000 customers, each one with 100 sales transactions (invoices) and each invoice with 10 products, with this optimistic figures you are expecting 1000 x 100 x 10 = 1,000,000 rows to be shown on the UI, why? or who would be able to read (or work) 1 million rows on the screen (if you are lucky, you will be able to fit 30 or 40 rows per screen).

My question regarding this requirement is: Why do you want that? what is the real reason to show all the back-end transactions on the screen? the answer to these questions may lead to a different approach to sort out this requirement.

Hope this helps,

Arnaldo

[ValeriyaBartosh]

Hello, can you add a print screen?

[wanyunyang]

Hi Arnaldo, thank you for the reply. Actually it's not displaying sales transactions. The user wants to see the selling information for hundreds of items each customer, so there will be one row for every customer-item, and end up being hundreds of rows per customer.

[wanyunyang]

Hi Valeria, I'm not able to show a print screen with real data. Here's the scenario:

I need to show 300 rows (since there're 300 items to analysis) for each customer:

But this is what straight table in Qlik Sense shows:

[arulsettu]

you can use the pivot table. so under customer items will be shown

[wanyunyang]

Hi arul, I tried with pivot table as well. Same with straight table, showing 2 items for each customer only.

[rittermd]

If multiple rows are identical in every column then Qlik will only show the row one time.  Is that what you are experiencing?

Otherwise it should show all rows as far as I know.

[wanyunyang]

Hi Mark, no rows are the identical. I'm have problem displaying too much rows.

[rittermd]

I have to ask.  Do you have any kind of filtering going on in an expression in the table (Set analysis)? 

Are you sure that you actually have 300 rows of data that you loaded from your script?

I have always had the opposite problem.  I want to limit how many rows I display in a straight table.  I don't recall every running into not seeing all of them.