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.
If they are fields why not do like this in the script:
LOAD [%GrowthNY],
[%GrowthCY],
[TotalFTECY],
([TotalFTECY] * [%GrowthNY])/100 AS [TotalFTENY]
FROM Source
I tried this and it displays nothing.Thank you.
Can you share few lines of data to look at?
do you have anything where its has how growth is calculated?
no..its an excel file
Can you store your data like this maybe?
TotalFTECY, %GrowthNY, Year
3735, 3, 2015
Table:
LOAD *,
([TotalFTECY] * [%GrowthNY])/100 AS [TotalFTENY];
LOAD * Inline [
TotalFTECY, %GrowthNY, Year
3735, 3, 2015
];
Output:
load TotalFTECY,
%GrowthCY,
%GrowthNY,
(TotalFTECY * purgechar(%GrowthNY,'%'))/purgechar(%GrowthCY,'%') as TotalFTENY
from xyz.xls;
edit:
As there's no %GrowthCY in your excel,
you can also try
load TotalFTECY,
%GrowthNY,
(TotalFTECY * purgechar(%GrowthNY,'%'))/100 as TotalFTENY
from xyz.xls;
This is pulling from the share point list and once they add more data it has to update accordingly