Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to show a table in dashboard

Hi Friends,

I loaded a table and created a pivot chart with only with some dimensions and with a unique policy number.

Now I want to show a entire records from the original table when the user is on only one policy number.

I created a table box and added all the dimensions to it and given condition to show the records related to the selected policy number only.

But I am not able to see all the records. Somehow its discarding some of the records.

Could I know the reason.

Thanks

Pavan

1 Solution

Accepted Solutions
Not applicable
Author

Are you sure you do not have any duplicate records?

Try adding a new dimension to your table on the load script:

RecNo() as RecordNumber

Then include this new dimension, RecordNumber to your table.

Also check that count(distinct YourRecorId) = count(RecordNumber).

View solution in original post

6 Replies
ashwanin
Specialist
Specialist

Hi

Please post some sample data.

Not applicable
Author

could you telll me how to just dump entire table onto dashboard??

Not applicable
Author

Are you sure you do not have any duplicate records?

Try adding a new dimension to your table on the load script:

RecNo() as RecordNumber

Then include this new dimension, RecordNumber to your table.

Also check that count(distinct YourRecorId) = count(RecordNumber).

rajeshvaswani77
Specialist III
Specialist III

Hi Pavan,

Can you post an example QVW file?

thanks,

Rajesh Vaswani

Not applicable
Author

Thanks Jose Its working

The table box is showing only related records.

But when I do sum on one column its taking lot of values other than selected policy number.

Does RecNo() effect the calucualtions.

Thanks

Pavan

Not applicable
Author

RecNo() should not affect your calculations. Think of it as an autonumber id column.