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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
chandra63
Creator
Creator

variables creation

Hi All,

I want to create variables like this.

  • total_od_recovered_above_90

(Total recovered /total OD) percent is above 90

  • total_od_recovered_76_90

(Total recovered /total OD) percent is between 76 and 90

  • total_od_51_75

(Total od/payment tenure) percent is between 51 and 75

  • total_od_above_90

(Total od/payment tenure) percent is above 90

  • total_od_recovered_51_75

(Total recovered /total OD) percent is between 51 and 75

  • total_od_76_90

(Total od/payment tenure) percent is between 76 and 90

  • total_od_26_50

(Total od/payment tenure) percent is between 26 and 50

  • total_od_recovered_26_50

(Total recovered /total OD) percent is between 26 and 50

  • sales_vintage_1

Age of the customer lifecycle is 2

  • pay_tenure_12

Payment tenure is 12

  • pay_tenure_24

Payment tenure is 24

  • total_emi_rlz_26_50

Total (recovered + non od)/payment_tenure percent is between 26 and 50

  • total_emi_rlz_51_75

Total (recovered + non od)/payment_tenure percent is between 51 and 75

I need help in resolving this.

Please help me here.

Thanks.

0 Replies