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
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:
Hi Ruben,
i have Problem with rows not about the columns, please suggest any solution
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
A sample screenshot would help get to the bottom of this.
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
Hi suresh, and how is the expression that creates the Dim column?
Dimension --> Dim
Expression --> count(Dim) (Basic Expression)
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
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.