Qlik Community

Qlik Sense App Development

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

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
LP27
Contributor

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
Contributor

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.