I am writing the Help for QlikView. I enter the content & format it in Excel, then imported into QlikView. The problem is, I am manually formatting the text in each Excel cell. I have to manually insert bullet points, spaces, indents, do the alt+enter to insert a line, etc. Then when I think I have everything correctly formatted, I import into QlikView and see how it displays. If anything is amiss, I must go back to the Excel file and fix it. This happens almost every time!! Question: is there a way you can format text in cells so the formatting settings are hard coded and preserved by QlikView? (instead of this painstaking trial-and-error method!) Thanks!
You cant load the format of the excel sheets into qlikview... you can use excel to load the data into qlikview and then you can create a chart (straight or pivot table) and you can do cell formating..
If you are using Qlikview SR5 you can right click on the cell and select 'custom format cell' or you can select 'Design Grid', and then right click on the chart and select custom format cell.
You don't have to make the changes in Excel, and you don't have to make the changes in every chart object. Instead, you would make the transformations in the load script. For example, if you want to specify that the field is a number, you would enclose it with a num() function. For text, you would use text(). You can apply date() or timestamp() functions, or date# or timestamp# transformations. You can trim extra spaces from cells with the trim() function. Take a look at the help file for a list of all formatting functions available.
Thank you! But my problem is, when I format the text in Excel, I inser lines, bullet points, indents, hard paragrah endingsm etc. The problem is, when the Help is imported into QlikView, all or most of the formatting is gone!
Thank you! But my problem is, when I format the text in Excel, I inser lines, bullet points, indents, hard paragrah endingsm etc. The problem is, when the Help is imported into QlikView, all or most of the formatting is gone!
And the text() function does not help with this? I suspect that you may need to insert the bullets and line breaks differently if that's the case. I would think that you can insert bullets and lines breaks as ASCII characters and they would be imported into QV along with the text. For example, your Excel cell content could look like this, which would result in "hello •": =TEXT("hello " & CHAR(149),"#"). This type of bullet point should be imported into QV without any problems. Similarly, you can nuse CHAR(10) for line breaks.
