topic Qliksense Table repeating same rows twice issue. in App Development

Qliksense Table repeating same rows twice issue.

suresh_qv50 — Tue, 20 Sep 2016 07:07:59 GMT

Hi Every one,

We are using Table in qliksense to display table of information.

our table has 10 rows, we have small space we reduced the space of table to half, when i scroll down the same set of rows repeating again.

Please suggest any solution to avoid this situation.

Thanks & Regards

suresh

Re: Qliksense Table repeating same rows twice issue.

rubenmarin — Tue, 20 Sep 2016 07:53:42 GMT

Hi suresh, it the table space has been reduced maybe there are other columns not shwon because the lack of space, export the table to excel and check if there are really repeated rows.

If there is no space to show all columns, there is a botton on the right of the table with 3 dots (it can be easily ignored), clicking on it you can select the rows to show:

Re: Qliksense Table repeating same rows twice issue.

suresh_qv50 — Tue, 20 Sep 2016 07:57:47 GMT

Hi Ruben,

i have Problem with rows not about the columns, please suggest any solution

Re: Qliksense Table repeating same rows twice issue.

rubenmarin — Tue, 20 Sep 2016 08:53:21 GMT

Hi suresh, Qlik doesn't shows two equal rows, so there should be a column wich have a different values between rows, please check what I said: export the entire table to excel and check the rows in the exported table.

Or attach the qvf to check the data, maybe there is a dual field or a date with the same representation in text but different internal value

Re: Qliksense Table repeating same rows twice issue.

simondachstr — Tue, 20 Sep 2016 08:56:34 GMT

A sample screenshot would help get to the bottom of this.

Re: Qliksense Table repeating same rows twice issue.

suresh_qv50 — Tue, 20 Sep 2016 11:36:07 GMT

Hi ,

I just attached the screen shots, please find the screen shots.

We have 11 bins in dimension, the table repeating same set of information again as shown in Screen2 Screen shot

Re: Qliksense Table repeating same rows twice issue.

rubenmarin — Tue, 20 Sep 2016 12:31:14 GMT

Hi suresh, and how is the expression that creates the Dim column?

Re: Qliksense Table repeating same rows twice issue.

suresh_qv50 — Tue, 20 Sep 2016 13:23:22 GMT

Dimension --> Dim

Expression --> count(Dim) (Basic Expression)

Re: Qliksense Table repeating same rows twice issue.

rubenmarin — Tue, 20 Sep 2016 13:29:35 GMT

If it's not a calculated dimension the expression that creates the Dim column should be in the script, and maybe is created using Dual, because of that there are show as if they where equal but internally they have different value:

In example one of the '$0-$10k' can have a stored value of 0 and the other of 9.99.

You can check this adding an expression with "=Num(Dim)" and check if it returns a different value for the same Dim value

Re: Qliksense Table repeating same rows twice issue.

suresh_qv50 — Tue, 20 Sep 2016 13:34:40 GMT

If i increase the table height i was perfect, when i reduce the table height its repeating same values again.

Pls find the attached screen shot after increasing the height.

Re: Qliksense Table repeating same rows twice issue.

rubenmarin — Tue, 20 Sep 2016 13:41:45 GMT

I never found that issue, I will need a sample to provide help.