topic Re: Dialog different from table in QlikView

Dialog different from table

easternfish — Mon, 02 Oct 2017 16:01:29 GMT

Hi,

When I go to "Table Viewer" right click to preview the "Dialog" it shows my information but when I create a new "Chart" or "Table box" it shows me less information. the "Dialog" previewer shows me 4 records but the "Chart" or "Table box" shows only 2 records.

What would cause the Dialog box be different from a table or chart?

thank you in advance!

Re: Dialog different from table

krishnacbe — Mon, 02 Oct 2017 16:04:13 GMT

Share the image or application to check the issue

Re: Dialog different from table

easternfish — Mon, 02 Oct 2017 16:14:32 GMT

Re: Dialog different from table

krishnacbe — Mon, 02 Oct 2017 16:16:15 GMT

It is showing the Distinct values.

what I the expression you have used in the chart?

Re: Dialog different from table

easternfish — Mon, 02 Oct 2017 17:20:45 GMT

no expression. even if i create a table box or a list box it only shows 3 records instead of the 6.

Re: Dialog different from table

krishnacbe — Mon, 02 Oct 2017 17:29:11 GMT

In List box or Table box, by default it will show only distinct Values. You should add the other columns which has values that are not distinct.

Re: Dialog different from table

easternfish — Mon, 02 Oct 2017 17:41:44 GMT

that's correct I was just trying to give you more samples on were the records are not displaying properly. it seems to only work when I create a basic Chart using SUM(Quantity) and not just Quantity. I shouldn't have to do this it should just display the same as the Database (Dialog box).

Re: Dialog different from table

krishnacbe — Mon, 02 Oct 2017 17:51:59 GMT

So the Column which has unique values are Quantity.

If you add Quantity as your Dimension the issue will be solved I Hope. for expression just add 1 and hide that column in Presentation tab.

Re: Dialog different from table

easternfish — Mon, 02 Oct 2017 18:10:30 GMT

here's what the report displays. I need the chart to look like the original.

thanks for your help so far!!!

Re: Dialog different from table

krishnacbe — Mon, 02 Oct 2017 18:29:20 GMT

Hope the Attached file will solve your issue. I have added RowNo to the records and hided the column

Re: Dialog different from table

Frank_Hartmann — Mon, 02 Oct 2017 18:29:45 GMT

see attached file

hope this helps

Re: Dialog different from table

easternfish — Mon, 02 Oct 2017 18:41:03 GMT

thank you for all the help. adding the Row works.

Re: Dialog different from table

krishnacbe — Mon, 02 Oct 2017 18:42:24 GMT

Good to hear.

Please mark the correct/helpful answer and close the thread.