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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
tizianacaem
Partner - Contributor
Partner - Contributor

problem with expression

Hello all.
I have a problem with a calculation of expressions.
In lines of expression I have calculated the sales of Year and PreviousYear.
If I show the year such size in column, is there a way to see both expressions in all the columns, like the following example?

2009 2010 2011

sales year sales2009 sales2010 sales2011

sales PreviousYear sales2008 sales2009 sales2010

thanks

Tiziana


2 Replies
renjithpl
Specialist
Specialist

hi tizia,

can you just explain your scenario little more detail?

whats are the two expressions?

Thanks

brenner_martina
Partner - Specialist II
Partner - Specialist II

Hi Tiziana,

I think you mean to show in the table the result of the expression and the year, yes, this is possible, you can concatenate Text and expressions by using &:

=Year&': '&Num(Sum(Sales),'#,##0')