topic Re: QlikView 12.10 migration issue with Num() format in QlikView

QlikView 12.10 migration issue with Num() format

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi!

I'm upgrading from Qlikview v11.20 to v12.10 and I'm having an issue using the only() function to get the right format for my Num() expression.

This is an example:

num(sum({<cod_ind={$(vGrafico1)},KPI={2}>}KPI_VALOR),only({<cod_ind={$(vGrafico1)}>}KPI_FORMAT))

Using the above it returns an internal fatal error.

I'm not sure what's the problem... I've tried using other functions for the format parameter and it works perfectly but the only() function doesn't.

Re: QlikView 12.10 migration issue with Num() format

m_woolf — Mon, 20 Nov 2017 19:14:18 GMT

What do you get if you put

=only({<cod_ind={$(vGrafico1)}>}KPI_FORMAT)

in a text box?

Re: QlikView 12.10 migration issue with Num() format

Anonymous — Mon, 20 Nov 2017 20:46:24 GMT

I got the right format string

Re: QlikView 12.10 migration issue with Num() format

m_woolf — Tue, 21 Nov 2017 12:56:09 GMT

Including the aprostrophies?

Re: QlikView 12.10 migration issue with Num() format

Anonymous — Wed, 22 Nov 2017 09:18:24 GMT

No, but I've tried to concatenate the apostrophes on the num() format parameter and it doesn't work.

Re: QlikView 12.10 migration issue with Num() format

Anonymous — Wed, 22 Nov 2017 13:05:05 GMT

I found a work around but it's not clean. Maybe this give you more information.

this works:

=num(sum({<cod_ind={$(vGrafico1)},KPI={2}>}KPI_VALOR), ''&only({<cod_ind={$(vGrafico1)}>}KPI_FORMAT&''))

this doesn't work:

=num(sum({<cod_ind={$(vGrafico1)},KPI={2}>}KPI_VALOR), text(only({<cod_ind={$(vGrafico1)}>}KPI_FORMAT)))