Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
alejandro_guill
Contributor II
Contributor II

QlikView 12.10 migration issue with Num() format

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.

5 Replies
m_woolf
Master II
Master II

What do you get if you put

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

in a text box?

alejandro_guill
Contributor II
Contributor II
Author

I got the right format string

m_woolf
Master II
Master II

Including the aprostrophies?

alejandro_guill
Contributor II
Contributor II
Author

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

alejandro_guill
Contributor II
Contributor II
Author

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