Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

easternfish
New Contributor III

Dialog different from table

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!

1 Solution

Accepted Solutions
Partner
Partner

Re: Dialog different from table

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

View solution in original post

12 Replies
Partner
Partner

Re: Dialog different from table

Share the image or application to check the issue

easternfish
New Contributor III

Re: Dialog different from table

Dialog.pngtable.png

Partner
Partner

Re: Dialog different from table

It is showing the Distinct values.

what I the expression you have used in the chart?

Highlighted
easternfish
New Contributor III

Re: Dialog different from table

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

Partner
Partner

Re: Dialog different from table

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.

easternfish
New Contributor III

Re: Dialog different from table

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).

Partner
Partner

Re: Dialog different from table

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.

easternfish
New Contributor III

Re: Dialog different from table

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

thanks for your help so far!!!

sample.png

Partner
Partner

Re: Dialog different from table

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

View solution in original post