Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
What do you get if you put
=only({<cod_ind={$(vGrafico1)}>}KPI_FORMAT)
in a text box?
I got the right format string
Including the aprostrophies?
No, but I've tried to concatenate the apostrophes on the num() format parameter and it doesn't work.
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)))