Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: How to show a table in dashboard

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

6 Replies
ashwanin
Not applicable

Re: How to show a table in dashboard

Hi

Please post some sample data.

Not applicable

Re: How to show a table in dashboard

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

Not applicable

Re: How to show a table in dashboard

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
Not applicable

Re: How to show a table in dashboard

Hi Pavan,

Can you post an example QVW file?

thanks,

Rajesh Vaswani

Not applicable

Re: How to show a table in dashboard

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

Re: How to show a table in dashboard

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