topic Re: dynamic custom straight table in QlikView

dynamic custom straight table

savithri_n_s — Mon, 30 Dec 2019 09:31:02 GMT

Hi Team,

I have inserted dynamic straight table. Data source i am not getting both the values - Cx managed and Cx enabled.

I have attached the qvw file.

When i export to excel i should get count of 57 k plus

Please can you help me?

Regards,

Savithri

Re: dynamic custom straight table

kaushiknsolanki — Mon, 30 Dec 2019 10:17:20 GMT

Hi,

The App is protected by Section Access.

Kindly share without section access, or share the username password.

Regards,

Kaushik Solanki

Re: dynamic custom straight table

savithri_n_s — Mon, 30 Dec 2019 10:54:41 GMT

Hi Kaushik

Please find the qvw file removing section access

Regards,

Savithri

Re: dynamic custom straight table

sunny_talwar — Mon, 30 Dec 2019 15:10:23 GMT

What selection have you made in _Dimension and _metrics? Also, are you expecting 57k rows in the table or 57k sum for $ Hours MTD or something else?

Re: dynamic custom straight table

savithri_n_s — Tue, 31 Dec 2019 04:55:26 GMT

57 k rows with dimension as po req nbr and data source and measure as $hours mtd

Re: dynamic custom straight table

sunny_talwar — Tue, 31 Dec 2019 13:20:19 GMT

Based on the selections you mentioned, I see 57,371 rows... is that not right?

Re: dynamic custom straight table

savithri_n_s — Thu, 02 Jan 2020 04:09:42 GMT

Hi Sunny,

Rows count here shows right 57,371. When i export the same data to excel its shows 26574. Can you please help?

Regards,

Savithri

Re: dynamic custom straight table

Brett_Bleess — Thu, 02 Jan 2020 14:26:16 GMT

Mystery solved, the issue is you have Suppress Zero-Values checked on the Presentation tab settings of your Straight Table for the PO / ReqNbr field, which is dropping all the 0 value rows because they are not showing in the Straight Table, the total shows due to your expression... Simply unchecking the Suppress Zero-Values will do the trick, am attaching the QVW though with the change already done, so you can see what is wrong, as it will now export all the rows, and you will notice the 0 value rows, which are not in your Straight Table view...

Regards,
Brett

Re: dynamic custom straight table

savithri_n_s — Fri, 03 Jan 2020 04:42:51 GMT

Thank you soo much Brett

Re: dynamic custom straight table

Brett_Bleess — Mon, 06 Jan 2020 13:10:23 GMT

Just a further note on how I went about troubleshooting things for others. I did what you were doing first to be sure I could replicate what you were seeing, and that was doable, so then I kept working on looking at things in more detail by looking in the Table Viewer etc. to see what the actual data model looked like and how things were linked. I also did a List Box object on one of the fields to be sure there were not duplicates showing up there, which there were not, but that made it clear there were records missing, and that is when it occurred to me after having seen 0 value records in the Table Viewer that suppress zero values may be set... Hopefully this may help folks in the future. Thanks for marking things as solved too, much appreciated and glad I was able to help you on this one, normally I am not too good on the development posts, but I got lucky on this one! 🙂

Cheers,
Brett