topic Re: Conditional Number Formatting in QlikView

Conditional Number Formatting

Tue, 26 Jul 2011 03:01:12 GMT

A question from a newbie here. I have a chart where I've parameterized the calculation for the value axis. I let the user choose whether they want to view the frequency of an occurance, the hours lost or the dollar value of that time. What I'd like to do is to set the number formatting based on that selection. I believe this can be done right from the expression by using code like the following:

if(ChartMeasure = 'Dollars', num(sum(duration)*75/3600, '$#,##0.00'),

if(ChartMeasure = 'Frequency', num(count(ent_id), '#,##0'),

if(ChartMeasure = 'Hours', num(sum(duration)/3600, '#,##0.0 hrs'))

)

and then setting the expression number format settings to "expression default" in the number tab. However, this doesn't seem to be working as I get the same generic formatting no matter what I select. I know the if statement is being executed, though, as the numbers come out correct for the calculations.

Any help would be greatly appreciated!

Conditional Number Formatting

IAMDV — Tue, 26 Jul 2011 09:19:09 GMT

Hi Tim,

Good morning.

Is the formatting set to expression default instead ofInteger or other format type? Please can you upload your QV document withscrambled or sample data? I can work out this for you...

Hope this helps!

Cheers - DV

Re: Conditional Number Formatting

Tue, 26 Jul 2011 22:17:19 GMT

Sure thing. Thanks for the help!

Re: Conditional Number Formatting

Fri, 29 Jul 2011 19:26:07 GMT

Sorry to pester, but were you (or anyone else) able to take a look at the document?

Thanks again!

Conditional Number Formatting

johnw — Fri, 29 Jul 2011 23:29:50 GMT

Using your fast change icon, we can see that the only chart the formatting is failing on is the bar chart. All your other chart types appear correct. Even on the bar chart, the pop up values are correct. Hmmm, maybe I'm remembering older versions of QlikView, but thought there were two checkboxes - text on data point and value on data point. One was formatted and one wasn't, I think. Surely that option has moved somewhere else, then, and we just have the wrong options selected? If we tell it to plot values inside segments, that gets the right formatting. What's so special about plotting a value at the top of the bar?

Anyway, I'm not finding it. I supsect there's a checkbox or radio button somewhere in the properties that will make it work, but I also won't be surprised if it's a bug.

Re: Conditional Number Formatting

Sat, 30 Jul 2011 13:57:05 GMT

John,

I think you're correct that it is a bug in this version. However, plotting the value inside the segment is a good enough work around. Thank you very much!

Re: Conditional Number Formatting

Anonymous — Fri, 11 Nov 2016 11:21:42 GMT

please try this i think it solved problem of conditional number formatting

num((if(vSelectionButton=1,Sum(expression1)

,if(vSelectionButton=2,Sum(expression1)

))),if(vSelectionButton=1,'$ #,##','#,##0.00'))

Reagrds,

Dixit Panchal

Re: Conditional Number Formatting

qlikdelqbz — Mon, 18 Mar 2019 15:18:02 GMT

unfortunately it still does not work for me. at least in 2018 Nov version.