search

iviasensio / PLSmartPivot

PL Smart Pivot Report for Qlik Sense
MIT License
19 stars 19 forks source link

user-defined customer number formats not being respected in IF statements #13

Open DMauriceAU opened 6 years ago

DMauriceAU commented 6 years ago

In the drop-down options for number formats I can see that as well as the "Auto" function there is a "Measure Expression" selection. Defining a measure with a custom number format (and having Qlik Sense respect it by selecting "Auto") is working with the extension, as long as only one format is selected.

In the case in the Apps we are developing, we've adjusted the data to have percentages in the same measure as amounts (for our own reporting), and in a straight table we can use IF statements for format these correctly.

In the extension, it looks like during your parsing and allowing scale adjustments this may be being dropped, I'm not sure exactly where though. The array MeasuresFormat seems to hold all of these?

DMauriceAU commented 6 years ago

Also seems to inconsistently have problems with number formats specified in measures containing an optional zero specifier, for example: num([VALUE], '#,##0;(#,##0);-')

screenshot

QlikGarten commented 5 years ago

Hi,

I'm in the exact same position, need amount combined with % in one and same column, however, the extension seems to only support one format per column, regardless of whether I set % on some of the rows.

Kind regards,

Joakim

iviasensio commented 5 years ago

@QlikGarten, there is a trick, if your account label starts with the char '%', then the number mask will change automatically to percent format 0,00%

QlikGarten commented 5 years ago

Hi,

Thanks! And if I need to see % on some of the column on this specific row, while I need to show it as p.p.t on some of the columns (In other words apply a text format for p.p.t) on the exact same row, would that be possible as well?