Discussion Board for collaboration on QlikView Layout & Visualizations.
I want to display data in straight table and data is in below format.
I am getting values in point format after calculating it from different fields and basis on this value (ans of that calculation) I want to map it with below table.
for example if ans of calculation is = to 1.6 it must display 2, if ans is less than 1.5 it must display 1 and so on
Please help me in getting this output.
Try like ths
=If(Column(1) <= 1.5, 1.
if(Column(1) = 1.6, 2,
If(Column(1) = 1.7, 3, 4)))
And Hide the Value Column in presentation tab, if its not required
Hope it helps you
Hi, I have tried this.....but the fact is that I have too many(say 100) of such values to map.. So that will be a lot of work ..I guess.. Is there any other way..in which we can achieve this..
Is the mapping going to be dynamic? If not then do this in the script using Mapping Load may be
if you want to avoid results in point format e.g. 1.6 then you can use the round formula, eg round(6/4), the result is 2 not 1.5.
I hope it will helps you!
if you have limited set of values to map then you could create a inline table and map the data using the applymap function.
Mapping LOAD * inline
applymap('Temp',Value,null()) as Round_value
from table ;
I my scenario, i have 3 excel source in different data format
excel one contains data in the format
in the above table we have to load where comm type = 'Pre'
and score table as shown in first message.
Score of every employee is calculated as follows Sum(Count) / count(Comm Type).
I am unable to achieve this in backend and that the reason i calculated it straight table and want to map each partners value in frontend