https://community.qlik.com/t5/App-Development/Missing-rows-in-pivot-tables/m-p/1766651#M59313 <P>Hello,</P><P>I am working on an App containing two pivot tables.</P><P>Source of data contains around 290 rows.</P><P>When data is inserted into pivot tables as dimensions, it turns out that there are quite a no. of rows went missing.</P><P>I am having a hard time to understand this.</P><P>&nbsp;</P><P>I checked that 290 rows (excel file) were correctly loaded into the App..</P><P>&nbsp;</P><P>Could you please help me on this?</P><P>&nbsp;</P><P>Thank you</P> Mon, 07 Dec 2020 11:04:03 GMT Cindy821 2020-12-07T11:04:03Z https://community.qlik.com/t5/App-Development/Missing-rows-in-pivot-tables/m-p/1766651#M59313 <P>Hello,</P><P>I am working on an App containing two pivot tables.</P><P>Source of data contains around 290 rows.</P><P>When data is inserted into pivot tables as dimensions, it turns out that there are quite a no. of rows went missing.</P><P>I am having a hard time to understand this.</P><P>&nbsp;</P><P>I checked that 290 rows (excel file) were correctly loaded into the App..</P><P>&nbsp;</P><P>Could you please help me on this?</P><P>&nbsp;</P><P>Thank you</P> Mon, 07 Dec 2020 11:04:03 GMT https://community.qlik.com/t5/App-Development/Missing-rows-in-pivot-tables/m-p/1766651#M59313 Cindy821 2020-12-07T11:04:03Z https://community.qlik.com/t5/App-Development/Missing-rows-in-pivot-tables/m-p/1766686#M59316 <P>When you say missing rows, how are you determining that rows are missing?&nbsp; When you add a dimension to a pivot or straight table, it will show the unique values for that dimension (or group of dimensions).&nbsp; If a dimension only has 10 unique values, you will see 10 rows, not 290.</P> Mon, 07 Dec 2020 13:26:03 GMT https://community.qlik.com/t5/App-Development/Missing-rows-in-pivot-tables/m-p/1766686#M59316 GaryGiles 2020-12-07T13:26:03Z