topic Re: Conditional num formatting in QlikView

Conditional num formatting

Anonymous — Fri, 15 Apr 2016 18:43:48 GMT

Hello,

I'm having an issue with conditional number formatting. Whenever ACTUAL_CALCULATION is Rate, I want the result to be in a percentage, otherwise, I want the number rounded to 2 decimal places.

When the expression is evaluated, however, the 'Rates' are not coming back as percentages. If I click on 1 record though, the format does correctly change to an percentage.

Is there something I'm doing wrong in my expression below?

if (	ACTUAL_CALCULATION = 'Rate',num(Sum(NUMERATOR)/sum(DENOMINATOR),'#,###.00%'),

if (ACTUAL_CALCULATION = 'Sum', num(sum(SUM),'#,##0.00'),

if (ACTUAL_CALCULATION = 'Median', num(Median(SUM),'#,##0.00'),
	if (ACTUAL_CALCULATION = 'Formula', 0,0
		)
	)
)

)

Re: Conditional num formatting

sunny_talwar — Fri, 15 Apr 2016 18:45:26 GMT

Have you selected 'Expression Default' on the Number's tab of the chart properties? If not select that and it should work

Re: Conditional num formatting

Peter_Cammaert — Fri, 15 Apr 2016 18:47:21 GMT

When complex setups suddenly start to work when you select a single item, this usually means that one of the components of your expression returns many values whenever two or more rows are active.

For example, how many values does field ACTUAL_CALCULATION contain when more than one record is active?

Re: Conditional num formatting

Anonymous — Fri, 15 Apr 2016 18:48:06 GMT

Hello Sunny,

Yes, the format settings are set to Expression Default

Re: Conditional num formatting

Anonymous — Fri, 15 Apr 2016 18:52:41 GMT

ACTUAL_CALCULATION contains four values: Formula, Median, Rate, and Sum.

If I filter on Rate the results of the expression give me a long decimal, seemingly ignoring the num function altogether.

Re: Conditional num formatting

sunny_talwar — Fri, 15 Apr 2016 18:55:15 GMT

Would it be possible to look at a sample where you have this issue?

Re: Conditional num formatting

Anonymous — Tue, 19 Apr 2016 21:06:02 GMT

I realized my mistake. I had "Full Accumulation" mistakenly checked. When I checked "No Accumulation", the expression worked.