Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Team,
Please refer the below table.The date field value is Null(-) but the value is display left side i need to move it to rightside in Qliksense.Please advise
Please refer the below tables
ID | DATE |
123 | 06/08/2020 |
456 | 07/08/2020 |
872 | 08/08/2020 |
912 | - |
123 | 09/08/2020 |
238 | - |
Thanks in advance
RK
If you are using the table chart, you can adjust the alignment of the entire column, but not the null specifically. In your your table select the date tab and open it. Scroll down and toggle off auto alignment. Choose right align.
Already the date value is in right side only Null value is displaying in left side please refer below :
ID | DATE |
123 | 06/08/2020 |
456 | 07/08/2020 |
872 | 08/08/2020 |
912 | - |
123 | 09/08/2020 |
238 | - |
Hi,
Try this: Date(Num(DATE)) and change the text alignment to Right
Already the date Value is displaying at the right side.For null value is displaying at right side i need to move null value also in right side.
I am facing the some other issue in alignment.In a report for all columns it is right aligned.But when we export the data into excel I am seeing for few of the columns are left aligned.Please advise ..How to overcome this issue
Hello Team
For Null Value again i am facing some issue .For the below mentioned column in Qlik sense UI it is appearing as right But when i export it to excel it is appearing as Left side.But my requirment is to apply right side.Even i wrote the used the Round fun but it is a 4 digit value when i apply the round function it is display only 1 digit.
Please advise
And one more issue in code column if it is blank then it as to be display as '---' I have used the formula
If((Code=' ' ),'---',Code) as "Code",
But this formula is not working
Please advise .
The alignment in Excel is handled by Excel itself, and you can't change that from Sense, unfortunately.
Creating an NPrinting report would allow you to handle this, but there is quite a cost associated with this.
In qlik sense it is appearing right side .But when i export it to excel the data is appearing left side.SO i had raised a issue