Qlik Community

App Development

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

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
kristeljoymalapitan

How to Convert character into number?

Hi can someone help me on this,
I got different results
My data is if dpd is greater than 1 and less than or equal to 30 then results will be 30
The ff are the scenario
:Previous data
Acct1 - dpd =30

If dpd >1 and dpd<=30,30,NA as prev_dpd


:Current data
Acct1 - dpd =28

If dpd >1 and dpd<=30,30,NA as curr_dpd

:Query to get the output
If prev_dpd = curr_dpd,'stabilized',NA as rollrates

The acct was classified as NA instead of statbilized

Thanks in advance
Labels (2)
0 Replies