topic Re: Create Flag in script in QlikView https://community.qlik.com/t5/QlikView/Create-Flag-in-script/m-p/1071125#M944666 <HTML><HEAD></HEAD><BODY><P>each id have different lock period</P></BODY></HTML> Tue, 12 Jan 2016 10:28:55 GMT stephenedberkg 2016-01-12T10:28:55Z Create Flag in script https://community.qlik.com/t5/QlikView/Create-Flag-in-script/m-p/1071119#M944660 <HTML><HEAD></HEAD><BODY><P>i have monthid and lock period as 2,3,0.</P><P></P><P>i have ID with month id and lock period.each id have the different lock period</P><P></P><P>i want to add this lock period with month id and to create flag for each lock period</P><P></P><P>like</P><P></P><P>month id&nbsp; lock period&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MonthIDs</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</SPAN></P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P>4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6</P><P>5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7</P><P></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</SPAN></P><P style="font-size: 13.3333px;">2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P style="font-size: 13.3333px;">3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P style="font-size: 13.3333px;">4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</P><P style="font-size: 13.3333px;">5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</SPAN></P><P style="font-size: 13.3333px;">2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P style="font-size: 13.3333px;">3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6</P><P style="font-size: 13.3333px;">4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7</P><P style="font-size: 13.3333px;">5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8</P></BODY></HTML> Tue, 12 Jan 2016 10:19:21 GMT https://community.qlik.com/t5/QlikView/Create-Flag-in-script/m-p/1071119#M944660 stephenedberkg 2016-01-12T10:19:21Z Re: Create Flag in script https://community.qlik.com/t5/QlikView/Create-Flag-in-script/m-p/1071120#M944661 <HTML><HEAD></HEAD><BODY><P>What is the logic to add Lock Period in your script??</P></BODY></HTML> Tue, 12 Jan 2016 10:22:47 GMT https://community.qlik.com/t5/QlikView/Create-Flag-in-script/m-p/1071120#M944661 Anonymous 2016-01-12T10:22:47Z Re: Create Flag in script https://community.qlik.com/t5/QlikView/Create-Flag-in-script/m-p/1071121#M944662 <HTML><HEAD></HEAD><BODY><P>i want to calculate the sales amount using lock period only.</P><P></P><P>for MTD i want to calculate the sales after lock period month.</P></BODY></HTML> Tue, 12 Jan 2016 10:26:11 GMT https://community.qlik.com/t5/QlikView/Create-Flag-in-script/m-p/1071121#M944662 stephenedberkg 2016-01-12T10:26:11Z Re: Create Flag in script https://community.qlik.com/t5/QlikView/Create-Flag-in-script/m-p/1071122#M944663 <HTML><HEAD></HEAD><BODY><P>what is the data &amp; expected output?</P></BODY></HTML> Tue, 12 Jan 2016 10:26:28 GMT https://community.qlik.com/t5/QlikView/Create-Flag-in-script/m-p/1071122#M944663 Kushal_Chawda 2016-01-12T10:26:28Z Re: Create Flag in script https://community.qlik.com/t5/QlikView/Create-Flag-in-script/m-p/1071123#M944664 <HTML><HEAD></HEAD><BODY><P>Thats Fine, You are having ID and MonthID only in your table, and you want to insert Lock Period Flag in the table on what basis or criteria??</P></BODY></HTML> Tue, 12 Jan 2016 10:27:51 GMT https://community.qlik.com/t5/QlikView/Create-Flag-in-script/m-p/1071123#M944664 Anonymous 2016-01-12T10:27:51Z Re: Create Flag in script https://community.qlik.com/t5/QlikView/Create-Flag-in-script/m-p/1071124#M944665 <HTML><HEAD></HEAD><BODY><P>is this ur thread?</P><P></P><P><A href="https://community.qlik.com/message/944445">Re: Set analysis based on lock period</A></P></BODY></HTML> Tue, 12 Jan 2016 10:28:53 GMT https://community.qlik.com/t5/QlikView/Create-Flag-in-script/m-p/1071124#M944665 Chanty4u 2016-01-12T10:28:53Z Re: Create Flag in script https://community.qlik.com/t5/QlikView/Create-Flag-in-script/m-p/1071125#M944666 <HTML><HEAD></HEAD><BODY><P>each id have different lock period</P></BODY></HTML> Tue, 12 Jan 2016 10:28:55 GMT https://community.qlik.com/t5/QlikView/Create-Flag-in-script/m-p/1071125#M944666 stephenedberkg 2016-01-12T10:28:55Z Re: Create Flag in script https://community.qlik.com/t5/QlikView/Create-Flag-in-script/m-p/1071126#M944667 <HTML><HEAD></HEAD><BODY><P>yeah its my thread suresh</P></BODY></HTML> Tue, 12 Jan 2016 10:30:44 GMT https://community.qlik.com/t5/QlikView/Create-Flag-in-script/m-p/1071126#M944667 stephenedberkg 2016-01-12T10:30:44Z Re: Create Flag in script https://community.qlik.com/t5/QlikView/Create-Flag-in-script/m-p/1071127#M944668 <HTML><HEAD></HEAD><BODY><P>Why not create a inline function like this and link it in your data model?</P><P></P><P>Load * inline</P><P>[MonthID, Lock Period</P><P>1, 2</P><P>2, 2</P><P>3,2</P><P>4,0</P><P>5,0</P><P></P><P>so on...</P><P>];</P></BODY></HTML> Tue, 12 Jan 2016 10:32:00 GMT https://community.qlik.com/t5/QlikView/Create-Flag-in-script/m-p/1071127#M944668 Anonymous 2016-01-12T10:32:00Z Re: Create Flag in script https://community.qlik.com/t5/QlikView/Create-Flag-in-script/m-p/1071128#M944669 <HTML><HEAD></HEAD><BODY><P>month id + lock period</P><P></P><P>i want to create the flag for&nbsp; lock period</P></BODY></HTML> Tue, 12 Jan 2016 10:34:20 GMT https://community.qlik.com/t5/QlikView/Create-Flag-in-script/m-p/1071128#M944669 stephenedberkg 2016-01-12T10:34:20Z Re: Create Flag in script https://community.qlik.com/t5/QlikView/Create-Flag-in-script/m-p/1071129#M944670 <HTML><HEAD></HEAD><BODY><P>i have lot of month id and id .</P><P>each id have lock period.</P><P></P><P>its not possible for inline</P></BODY></HTML> Tue, 12 Jan 2016 10:36:08 GMT https://community.qlik.com/t5/QlikView/Create-Flag-in-script/m-p/1071129#M944670 stephenedberkg 2016-01-12T10:36:08Z Re: Create Flag in script https://community.qlik.com/t5/QlikView/Create-Flag-in-script/m-p/1071130#M944671 <HTML><HEAD></HEAD><BODY><P>sample data??</P></BODY></HTML> Tue, 12 Jan 2016 10:40:53 GMT https://community.qlik.com/t5/QlikView/Create-Flag-in-script/m-p/1071130#M944671 Anonymous 2016-01-12T10:40:53Z Re: Create Flag in script https://community.qlik.com/t5/QlikView/Create-Flag-in-script/m-p/1071131#M944672 <HTML><HEAD></HEAD><BODY><P>!</P></BODY></HTML> Tue, 12 Jan 2016 10:50:20 GMT https://community.qlik.com/t5/QlikView/Create-Flag-in-script/m-p/1071131#M944672 stephenedberkg 2016-01-12T10:50:20Z