Qlik Community

Ask a Question

App Development

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

Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources. READ DETAILS
Showing results for 
Search instead for 
Did you mean: 

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