topic Re: Hardcode text at the end in qlikview in QlikView

Hardcode text at the end in qlikview

capriconuser — Fri, 22 Jan 2021 06:25:08 GMT

i have this expression

=Sum({<Date{'$(vEmDate)'},Email_Month=,Email_Year=>}Box_Size)

from that i have data like this

4.5

3.4

I want to paste 'GB' at the end like this

4.5 GB

3.4 GB

how I should I do that?

MindaugasBacius — Fri, 22 Jan 2021 06:36:21 GMT

In the front end you can modify the format properties:

capriconuser — Fri, 22 Jan 2021 07:12:04 GMT

@MindaugasBacius but my expression is in text object

MindaugasBacius — Fri, 22 Jan 2021 07:16:58 GMT

Then simply at the end of the code add & ' GB'.

capriconuser — Fri, 22 Jan 2021 07:20:45 GMT

@MindaugasBacius this shows 0 when i add GB

=Round(Sum({<Date={'$(vEDate)'},Email_Month=,Email_Year=>}Box_Size & 'GB'))

MindaugasBacius — Fri, 22 Jan 2021 07:54:45 GMT

=Sum({<Date{'$(vEmDate)'},Email_Month=,Email_Year=>}Box_Size) & ' GB'