- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What do you get if you put
=only({<cod_ind={$(vGrafico1)}>}KPI_FORMAT)
in a text box?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I got the right format string
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Including the aprostrophies?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
No, but I've tried to concatenate the apostrophes on the num() format parameter and it doesn't work.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)))