Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikers,
I am new to Qlik environment . I want to know logic for this scenario -
I have got Column as Decision Points and Year -
Decision Points | Year |
PR1 | 46 |
PR2 | 37 |
PR3 | 98 |
PR4 | 64 |
PR5 | 88 |
PR6 | 46 |
PR7 | 89 |
PR8 | 32 |
I want to now multiply pre defined numbers for the values in Decision Point column, like - all the values of Year column should be multiplied as -
If it is PR1 then 46(value in Year column ) * 16.05%(pre defined value).
If it is PR2 then 37(value in Year column ) * 7.80%(pre defined value).
If it is PR3 then 98(value in Year column ) * 10.13%(pre defined value).
If it is PR4 then 64(value in Year column ) * 11.14%(pre defined value).
If it is PR5 then 88(value in Year column ) * 10.11%(pre defined value).
If it is PR6 then 32(value in Year column ) * 25.38%(pre defined value).
If it is PR7 then 89(value in Year column ) * 10.88%(pre defined value).
If it is PR8 then 46(value in Year column ) * 8.32%(pre defined value).
Note : Pre-Defined values will be same as defined above for PR1 to PR8. Only values in years column will change.
can some one help me which this logic here please ?
Thanks in advance,
LP27
hi
your best option , is to load a table with mulitplier for each Decision Point value
this table could come from excel sheet and will have two fields :
Decision Point,multiplier
than you can use this expresion:
year*mulitplier