Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
LP27
New Contributor II

Multipy values with pre defined values in qlik sense

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
PR146
PR237
PR398
PR464
PR588
PR646
PR789
PR832

 

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 

 

 

2 Replies
Partner
Partner

Re: Multipy values with pre defined values in qlik sense

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 

LP27
New Contributor II

Re: Multipy values with pre defined values in qlik sense

Thanks for your reply!
Could you explain more in detail.
Moreover i want to do the scripting in data modeling and dont want to do it in excel and load the data.