topic Re: Header issue in QlikView

Header issue

arusanah — Wed, 15 Apr 2015 22:02:25 GMT

I am using this expression in my report

Num(SuM(Fact.CustomerSales*([CurrencyConversion.EUR - Budgeted Rate CFY])))/1000

while it executes the expression , i get " Garbage after EUR" as header .

Any Idea what could be the reason?

Re: Header issue

maxgro — Wed, 15 Apr 2015 22:12:49 GMT

2 fields?

[CurrencyConversion.EUR - Budgeted Rate CFY]

[CurrencyConversion.EUR] - [Budgeted Rate CFY]

Re: Header issue

arusanah — Thu, 16 Apr 2015 00:08:22 GMT

no Massimo

[CurrencyConversion.EUR - Budgeted Rate CFY]

this one field coming from Currency table.

Re: Header issue

ziadm — Thu, 16 Apr 2015 00:57:45 GMT

whta is Fact.CustomerSales is this a function or Selection state ?

Re: Header issue

danieloberbilli — Thu, 16 Apr 2015 02:19:24 GMT

Could it be that the 'EUR' in the error message is due to a mistake in another expression/dimension/condition where 'EUR' appears?

If this expression is the only possibility, it means that the field [CurrencyConversion.EUR - Budgeted Rate CFY] is not identified as such. e.g. if you use the field name in a variable you have to ensure that the [ ] are set in a proper way

Re: Header issue

arusanah — Thu, 16 Apr 2015 05:02:00 GMT

EUR is value in Currency Dimension in data model. But why would it give error in Report Header.

Re: Header issue

arusanah — Thu, 16 Apr 2015 05:03:12 GMT

In Fact table there is a field CustomerSales . and since Fact table uses qualifiers i.e y the field is Fact.CustomerSales

Re: Header issue

danieloberbilli — Thu, 16 Apr 2015 05:11:05 GMT

what do you mean with 'Report' header? is it the title in the caption of a chart object?

Re: Header issue

jonathandienst — Thu, 16 Apr 2015 05:18:50 GMT

I can't replicate your error - a small test model handles that expression in a table or a text box without a problem. I suggest that you post a sample model to investigate further.

BTW the Num() in that expression is redundant.

Re: Header issue

Thu, 16 Apr 2015 05:24:45 GMT

Hi Archana,

You can try this.

=Num(SuM(Fact.CustomerSales) * sum(([CurrencyConversion.EUR] - [Budgeted Rate CFY])))/1000