Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
kristeljoymalapitan

How to Multiply multiple value that will output one/same column using measure

Hi , can someone help me how to multiply using different value but results on the same column?

I have the dpd column the default percentage column and the OB amount column below

  • Dpd 0  - 0.01 - 500
  • Dpd 30 - 0.02 - 600
  • Dpd 60 - 0.03 - 700

The computaions will be:

Dpd 0 - 500*0.01 = 5

Dpd 30 - 600* 0.02 = 1.2

Dpd 60 - 700*0.03 = 21

The results will be on one column using measures

5

1.2

21

Thanks

 

 

 

Labels (1)
10 Replies
kristeljoymalapitan
Author

Hi Tim,

 

It works!

 

Thanks much