topic Split issue in New to Qlik Sense
https://community.qlik.com/t5/New-to-Qlik-Sense/Split-issue/m-p/1734069#M169142
<P>Hi have the following data below..</P><TABLE width="1261"><TBODY><TR><TD width="271"> </TD><TD width="150"> </TD><TD width="138"> </TD><TD width="205"> </TD><TD width="157"> </TD><TD width="166"> </TD><TD width="174"> </TD></TR><TR><TD>Reference</TD><TD> </TD><TD>Account No </TD><TD>Type</TD><TD>ACT</TD><TD>PL</TD><TD>If(ACT<PL,'Yes','No)</TD></TR><TR><TD>24356</TD><TD> </TD><TD>11709992</TD><TD>ACT</TD><TD>3545.44</TD><TD>0</TD><TD>?</TD></TR><TR><TD>24356</TD><TD> </TD><TD>11709992</TD><TD>PL</TD><TD>0</TD><TD>8745.44</TD><TD> </TD></TR><TR><TD>24359</TD><TD> </TD><TD>11709992</TD><TD>ACT</TD><TD>4486.99</TD><TD>0</TD><TD> </TD></TR><TR><TD>24359</TD><TD> </TD><TD>11709992</TD><TD>PL</TD><TD>0</TD><TD>1220.88</TD><TD> </TD></TR><TR><TD>24345</TD><TD> </TD><TD>11709992</TD><TD>PL</TD><TD>0</TD><TD>5567.87</TD><TD> </TD></TR><TR><TD>24345</TD><TD> </TD><TD>11709992</TD><TD>ACT</TD><TD>9874.55</TD><TD>0</TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>Reference</TD><TD> </TD><TD>Account No </TD><TD>ACT</TD><TD>PL</TD><TD>If(ACT<PL,'Yes','No)</TD><TD> </TD></TR><TR><TD>24356</TD><TD> </TD><TD>11709992</TD><TD>3545.44</TD><TD>8745.44</TD><TD>?</TD><TD> </TD></TR><TR><TD>24359</TD><TD> </TD><TD>11709992</TD><TD>4486.99</TD><TD>1220.88</TD><TD> </TD><TD> </TD></TR><TR><TD>24345</TD><TD> </TD><TD>11709992</TD><TD>9874.55</TD><TD>5567.87</TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD>When Iam trying to make </TD><TD>If(ACT<PL,'Yes','No)</TD><TD>it does not consider 3545 < 8745 rather it takes 3545.44 < 0. </TD><TD> </TD><TD> </TD></TR></TBODY></TABLE>Fri, 07 Aug 2020 11:41:23 GMTraadwiptec2020-08-07T11:41:23ZSplit issue
https://community.qlik.com/t5/New-to-Qlik-Sense/Split-issue/m-p/1734069#M169142
<P>Hi have the following data below..</P><TABLE width="1261"><TBODY><TR><TD width="271"> </TD><TD width="150"> </TD><TD width="138"> </TD><TD width="205"> </TD><TD width="157"> </TD><TD width="166"> </TD><TD width="174"> </TD></TR><TR><TD>Reference</TD><TD> </TD><TD>Account No </TD><TD>Type</TD><TD>ACT</TD><TD>PL</TD><TD>If(ACT<PL,'Yes','No)</TD></TR><TR><TD>24356</TD><TD> </TD><TD>11709992</TD><TD>ACT</TD><TD>3545.44</TD><TD>0</TD><TD>?</TD></TR><TR><TD>24356</TD><TD> </TD><TD>11709992</TD><TD>PL</TD><TD>0</TD><TD>8745.44</TD><TD> </TD></TR><TR><TD>24359</TD><TD> </TD><TD>11709992</TD><TD>ACT</TD><TD>4486.99</TD><TD>0</TD><TD> </TD></TR><TR><TD>24359</TD><TD> </TD><TD>11709992</TD><TD>PL</TD><TD>0</TD><TD>1220.88</TD><TD> </TD></TR><TR><TD>24345</TD><TD> </TD><TD>11709992</TD><TD>PL</TD><TD>0</TD><TD>5567.87</TD><TD> </TD></TR><TR><TD>24345</TD><TD> </TD><TD>11709992</TD><TD>ACT</TD><TD>9874.55</TD><TD>0</TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>Reference</TD><TD> </TD><TD>Account No </TD><TD>ACT</TD><TD>PL</TD><TD>If(ACT<PL,'Yes','No)</TD><TD> </TD></TR><TR><TD>24356</TD><TD> </TD><TD>11709992</TD><TD>3545.44</TD><TD>8745.44</TD><TD>?</TD><TD> </TD></TR><TR><TD>24359</TD><TD> </TD><TD>11709992</TD><TD>4486.99</TD><TD>1220.88</TD><TD> </TD><TD> </TD></TR><TR><TD>24345</TD><TD> </TD><TD>11709992</TD><TD>9874.55</TD><TD>5567.87</TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD>When Iam trying to make </TD><TD>If(ACT<PL,'Yes','No)</TD><TD>it does not consider 3545 < 8745 rather it takes 3545.44 < 0. </TD><TD> </TD><TD> </TD></TR></TBODY></TABLE>Fri, 07 Aug 2020 11:41:23 GMThttps://community.qlik.com/t5/New-to-Qlik-Sense/Split-issue/m-p/1734069#M169142raadwiptec2020-08-07T11:41:23ZRe: Split issue
https://community.qlik.com/t5/New-to-Qlik-Sense/Split-issue/m-p/1734117#M169149
<P>you need to combine act and pl rows into a single row</P><P>try with script like this.</P><P> </P><LI-CODE lang="markup">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;</LI-CODE><P> </P>Fri, 07 Aug 2020 13:45:26 GMThttps://community.qlik.com/t5/New-to-Qlik-Sense/Split-issue/m-p/1734117#M169149dilipranjith2020-08-07T13:45:26Z