Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
capriconuser
Creator
Creator

Hardcode text at the end in qlikview

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?

5 Replies
MindaugasBacius
Partner - Specialist III
Partner - Specialist III

In the front end you can modify the format properties:

Screenshot_2.jpg

capriconuser
Creator
Creator
Author

@MindaugasBacius  but my expression is in text object 

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

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

capriconuser
Creator
Creator
Author

@MindaugasBacius  this shows 0 when i add GB

=Round(Sum({<Date={'$(vEDate)'},Email_Month=,Email_Year=>}Box_Size & 'GB'))
MindaugasBacius
Partner - Specialist III
Partner - Specialist III

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