Unit Conversion and % Calculation Issue

Anonymous — Fri, 26 Jun 2015 09:14:17 GMT

Hi Team,

I need your help in unit conversions and % calculation.

Issue is I have a bar chart for sales for two consecutive years and the sale amount varies from year to year.(no dimension only expressions).

with my conversion expression bars are displaying their respective units(like millions and Billions).

but I have to show same unit for all the bars in the chart.

and the % also coming wrongly(Please have a look at attached snap.).

Expressions we are using are

Bars 1)Sum({<year={"$(Max(Year))"}Sales)---- for current year

2)Sum({<year={"$(Max(Year)-1)"}Sales

Unit Conversion:

if(Sum({<year={"$(Max(Year))"}Sales)>1000000,Num(Sum({<year={"$(Max(Year))"}Sales))/1000000,'#,##0.0M',Num(Sum({<year={"$(Max(Year))"}Sales)/1000,'#,##0.0K').

% Exp:(Sum({<year={"$(Max(Year))"}Sales)-Sum({<year={"$(Max(Year)-1)"}Sales))/Sum({<year={"$(Max(Year)-1)"}Sales.

Thanks in advance,

Anusha.K

topic Unit Conversion and % Calculation Issue in QlikView

Unit Conversion and % Calculation Issue