topic Qlikview Script in QlikView https://community.qlik.com/t5/QlikView/Qlikview-Script/m-p/116999#M18011 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">Hi,<BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">TABLE:</SPAN></P><P><SPAN style="font-size: 13.3333px;">NoConcatenate</SPAN></P><P><SPAN style="font-size: 13.3333px;">LOAD Distinct</SPAN></P><P><SPAN style="font-size: 13.3333px;">*,</SPAN></P><P><SPAN style="font-size: 13.3333px;">'1' as&nbsp;&nbsp; [KPI], </SPAN></P><P><SPAN lang="en">KPI takes the value 1 can someone explain to me in which case we can make this choice</SPAN></P><P><SPAN lang="en">Best regards </SPAN></P><P><SPAN lang="en">Maurice<BR /></SPAN></P></BODY></HTML> Wed, 08 Aug 2018 08:17:11 GMT MauriceLudo 2018-08-08T08:17:11Z Qlikview Script https://community.qlik.com/t5/QlikView/Qlikview-Script/m-p/116999#M18011 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">Hi,<BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">TABLE:</SPAN></P><P><SPAN style="font-size: 13.3333px;">NoConcatenate</SPAN></P><P><SPAN style="font-size: 13.3333px;">LOAD Distinct</SPAN></P><P><SPAN style="font-size: 13.3333px;">*,</SPAN></P><P><SPAN style="font-size: 13.3333px;">'1' as&nbsp;&nbsp; [KPI], </SPAN></P><P><SPAN lang="en">KPI takes the value 1 can someone explain to me in which case we can make this choice</SPAN></P><P><SPAN lang="en">Best regards </SPAN></P><P><SPAN lang="en">Maurice<BR /></SPAN></P></BODY></HTML> Wed, 08 Aug 2018 08:17:11 GMT https://community.qlik.com/t5/QlikView/Qlikview-Script/m-p/116999#M18011 MauriceLudo 2018-08-08T08:17:11Z Re: Qlikview Script https://community.qlik.com/t5/QlikView/Qlikview-Script/m-p/117000#M18012 <HTML><HEAD></HEAD><BODY><P>It is very hard to tell without having the overview of the full load and the source table ...</P><P></P><P>Often such values are flags to indicate a specific condition for some rows. The flag can be used later in set expressions or If() expressions in the UI without calculating the more complex conditon (which was done in the load script) and it will speed up the application.</P></BODY></HTML> Wed, 08 Aug 2018 08:25:37 GMT https://community.qlik.com/t5/QlikView/Qlikview-Script/m-p/117000#M18012 petter 2018-08-08T08:25:37Z