Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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'