Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Straight table column in qlikview showing blank in display (but the column is actually having data)

Hi,

I have a straight table in qlikview and a column particularly added as a dimension (which has values and not null) . But Qlikview straight table shows it as blank . If i click the column cell, I can see the value in the current selection and also in textbox . As well as if i export the entire straight table to excel I can see the value for the column populated and it is not blank.

Do you have any idea why the display of that particular column is shown as blank?

I also tried to add the column as expression and value as [column], but no luck.

Please let me know if anyone has any clue.

Thanks,

Matrix

1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

I found the issue finally. In the database side it looks to be column is having carriage return and the actual value flowing in next line. When you export to excel it will auto trim and Qlik will show such value as blank. Used trim finally in qlik to see the value in the dimension.

View solution in original post

4 Replies
Highlighted
Partner
Partner

Hi Matrix,

Maybe the text color and background color are the same, so the text becomes invisible?

It would help if you put some screenshots or the QVW for us to take a look.

Highlighted
Contributor III
Contributor III

Hi, I have checked on the text color and background color, there is no
formatting as such and even there is no custom formatting. Also there is
suppressing null values on the other expressions..my particular column
which is a dimension is somehow not visible in the straight table..
Sorry I can not share QVW file..
Highlighted
Contributor III
Contributor III

--I mean to tell there is NO suppressing null or missing values in the other expressions. Also i tried keep the same for dimension column. (to see if the values are coming), but no luck

Highlighted
Contributor III
Contributor III

I found the issue finally. In the database side it looks to be column is having carriage return and the actual value flowing in next line. When you export to excel it will auto trim and Qlik will show such value as blank. Used trim finally in qlik to see the value in the dimension.

View solution in original post