Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 3 fields.
%Growth,%GrowthCY and TotalFTECY
TotalFTECY=3735
%GrowthCY=100%
%GrowthNY = 3%
now I need to calculate TotalFTENY
So basically it is (3735*3)/100
How can I do this in qlikview?
Thanks much.
Try this in that case:
(Num#(KeepChar([TotalFTECY], '0123456789'), '##') * Num#(KeepChar([%GrowthNY], '0123456789'), '##'))/100 AS [TotalFTENY]
Hi,
Try as below and see the result,
LOAD TotalFECY,
%GrowthNY,
%GrowthCY,
([TotalFECY]*[%GrowthNY])/[%GrowthCY] as TotalFTENY
FROM
(biff, embedded labels, table is Sheet1$);
Result:
Thanks,
Mahesh