Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Split issue

Hi have the following data below..

       
Reference Account No TypeACTPLIf(ACT<PL,'Yes','No)
24356 11709992ACT3545.440?
24356 11709992PL08745.44 
24359 11709992ACT4486.990 
24359 11709992PL01220.88 
24345 11709992PL05567.87 
24345 11709992ACT9874.550 
       
       
       
Reference Account No ACTPLIf(ACT<PL,'Yes','No) 
24356 117099923545.448745.44? 
24359 117099924486.991220.88  
24345 117099929874.555567.87  
       
 When Iam trying to make If(ACT<PL,'Yes','No)it does not consider 3545 < 8745  rather it takes 3545.44 < 0.   
Labels (1)
1 Reply
Highlighted
Partner
Partner

you need to combine act and pl rows into a single row

try with script like this.

 

tempmaintable:
load Reference,AccountNo,ACT	
from yoursource
where Type='ACT'
;
outer join (tempmaintable)
load Reference,AccountNo,PL
from yoursource
where Type='PL'
;


maintable:
load *
, If(ACT<PL,'Yes','No) as PlGreaterFlag
resident 
tempmaintable;

drop table tempmaintable;