topic Expression help in QlikView

Expression help

Mon, 07 Aug 2017 11:46:44 GMT

Hi,

I have a bit of a silly question but can't seem to get it working:

I have the following expression I want to use as a text object:

=sum({<FINMONTH = {'>$(=max(FINMONTH)-max(FINMONTH)) <= $(=max(FINMONTH))'}, FINYEAR = {'$(=MAX(FINYEAR))'}>}SALES)+sum({<FINMONTH = {'>$(=max(FINMONTH)-max(FINMONTH)) <= $(=max(FINMONTH))'}, FINYEAR = {'$(=MAX(FINYEAR))'}>}ENDOEXTRA)

I know to make it show in monetary value I need to add ,'£#,##0'' to the expression. However, when adding it to the end it's not working:

=sum(({<FINMONTH = {'>$(=max(FINMONTH)-max(FINMONTH)) <= $(=max(FINMONTH))'}, FINYEAR = {'$(=MAX(FINYEAR))'}>}SALES)+sum({<FINMONTH = {'>$(=max(FINMONTH)-max(FINMONTH)) <= $(=max(FINMONTH))'}, FINYEAR = {'$(=MAX(FINYEAR))'}>}ENDOEXTRA) ,'£#,##0'')

Any advice?

Re: Expression help

Anil_Babu_Samineni — Mon, 07 Aug 2017 11:49:47 GMT

You could use Num()

=Num(sum({<FINMONTH = {'>$(=max(FINMONTH)-max(FINMONTH)) <= $(=max(FINMONTH))'}, FINYEAR = {'$(=MAX(FINYEAR))'}>}SALES)+sum({<FINMONTH = {'>$(=max(FINMONTH)-max(FINMONTH)) <= $(=max(FINMONTH))'}, FINYEAR= {'$(=MAX(FINYEAR))'}>}ENDOEXTRA),'£#,##0')

Re: Expression help

Mon, 07 Aug 2017 11:51:41 GMT

Perfect! Knew it would be something really simple thank you!