Discussion Board for collaboration related to QlikView App Development.
This may be a silly question and but I am quite confused here. below the scenario.
I have the below load script
LOAD * ,Interest/Balance as Rate INLINE [Key, Interest, Balance1, 10, 52, 20, 253, 304, , 405, 50, 986, 60, 177, , 998, 100, 10009, 120, 1210, 140, 8];
and populating a table like below
But My expected table should look like below
I know we can't sum rates but how do we acheive the correct rates at all levels.
Please advice. I must calculate the rates on the load script.
Hi @techvarun ,
I copied your script into a new qlikview file and i got the following result:
The expression in rates column:
Chart Properties -> number format -> Rates
Please find the attachment for solution
Hope this works for you