topic Re: How to show a table in dashboard in QlikView

How to show a table in dashboard

Wed, 10 Dec 2014 11:31:32 GMT

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

ashwanin — Wed, 10 Dec 2014 11:39:38 GMT

Please post some sample data.

Wed, 10 Dec 2014 11:43:25 GMT

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

Wed, 10 Dec 2014 11:46:04 GMT

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 — Wed, 10 Dec 2014 11:51:42 GMT

Hi Pavan,

Can you post an example QVW file?

thanks,

Rajesh Vaswani

Wed, 10 Dec 2014 12:18:56 GMT

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

Wed, 10 Dec 2014 12:34:08 GMT

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