Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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'