topic AW:Re: problem with expression in QlikView

problem with expression

tizianacaem — Wed, 22 Sep 2010 13:31:53 GMT

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

problem with expression

renjithpl — Thu, 23 Sep 2010 06:38:35 GMT

hi tizia,

can you just explain your scenario little more detail?

whats are the two expressions?

Thanks

AW:Re: problem with expression

brenner_martina — Thu, 23 Sep 2010 07:59:19 GMT

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')