Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculation in staright Table

Hi All,

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

ValuePoints
< = 1.51
1.62
1.73
>=1.84

Please help me in getting this output.

6 Replies
MayilVahanan

Hi

Try like ths

Points

=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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

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..

sunny_talwar

Is the mapping going to be dynamic? If not then do this in the script using Mapping Load may be

maternmi
Creator II
Creator II

Hey,

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!

BR

Michael

avinashelite

if you have limited set of values to map then you could create a inline table and map the data using the applymap function.

Temp:

Mapping LOAD * inline

[

Value, Points

1,1

1.5,1

1.7,3

...

...

];

LOAD

applymap('Temp',Value,null()) as Round_value

from table ;

Not applicable
Author

Hi Everyone,

I my scenario, i have 3 excel source in different data format

excel one contains data in the format

     [SR]:

Manager NameEmployee NameMonth QuarterComm Type
HardikPriyanka11First
HardikMonika11Pre
HardikSarvesh11First
HardikAfsar11First
HardikRam11Pre
HardikSita11Pre
AnisAkhilesh11Pre
AnisRamesh11First
AnisSaravana11First
AnisPrashant11First
AnisPrathamesh11Pre
AnisAman11Pre
AnisRahul11Pre
HardikPriyanka21First
HardikMonika21First
HardikSarvesh21Pre
HardikAfsar21Pre
HardikRam21Pre
HardikSita21Pre
AnisAkhilesh21Pre
AnisRamesh21First
AnisSaravana21Pre
AnisPrashant21Pre
AnisPrathamesh21First
AnisAman21First
AnisRahul21First

in the above table we have to load where comm type = 'Pre'

      [Paid]:

Manager NameEmployee NameMonth Quartercount
HardikPriyanka111
HardikSarvesh111
HardikRam110
HardikSita111
AnisAkhilesh110
AnisRamesh111
AnisSaravana111
AnisPrashant110
AnisPrathamesh111
AnisAman111
AnisRahul110
HardikPriyanka211
HardikSarvesh211
HardikRam210
HardikSita211
AnisAkhilesh211
AnisRamesh210
AnisSaravana210
AnisPrashant210
AnisPrathamesh210
AnisAman210
AnisRahul211
HardikPayal310
HardikMohan314

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