topic Re: NoofRow function Vs Table view in QlikView

NoofRow function Vs Table view

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

Hi All

I am struggling to find out the reason why NoofRow function and Table display showing different values.

I have table which has 5532 records and count is correctly displays by NoofRow function, but when I showcase that table in tabular form and imported in excel,I can see count is 5491

I have reloaded it multiple times and behavior remains the same. Is that Table display treats it differently?

I am exhausted to find the solution.

Please suggest.

Re: NoofRow function Vs Table view

m_woolf — Mon, 06 May 2019 13:10:09 GMT

I suspect that you have duplicate rows.

If you add a line in your script: RowNo() as LineNo,

and then add the LineNo field into your tablebox, you should see all the rows.

Re: NoofRow function Vs Table view

vijaysahu2 — Mon, 06 May 2019 16:16:10 GMT

Thanks. I also validate because of duplicate records it is showing differently. However this behavior is misleading. Do we need to add Row no() with every load?

How this performs the join if these nos are different ? How we can avoid this ?

Re: NoofRow function Vs Table view

Brett_Bleess — Mon, 24 Jun 2019 21:52:23 GMT

Here is the best I can do for you to try to help, not sure if it is going to tell you what you want to know or not, but figured it was worth a try, but if your raw data is always going to have duplicates and you want to ensure you always have unique rows, you will need to use RowNo() or RecNo() or some other key to make each row unique to ensure things function as you want at that point, but hopefully the following link may shed some light upon things as to why this occurs in our data model. There are some additional links to some other blog posts at the bottom as well, just FYI.

https://community.qlik.com/t5/Qlik-Design-Blog/Symbol-Tables-and-Bit-Stuffed-Pointers/ba-p/1475369

Regards,
Brett