topic Re: Calculated Dimention/Sort Order/Original in QlikView https://community.qlik.com/t5/QlikView/Calculated-Dimention-Sort-Order-Original/m-p/1402619#M424996 <HTML><HEAD></HEAD><BODY><P>It is not working</P></BODY></HTML> Thu, 30 Nov 2017 10:11:48 GMT lylererger 2017-11-30T10:11:48Z Calculated Dimention/Sort Order/Original https://community.qlik.com/t5/QlikView/Calculated-Dimention-Sort-Order-Original/m-p/1402617#M424994 <HTML><HEAD></HEAD><BODY><P>Hi friends!</P><P></P><P>Help me to fix set analysis script of load order in chart.</P><P></P><P>Formula of calculated dimention is:</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_15120344739975799" jivemacro_uid="_15120344739975799"> <P>=Aggr( Only({1&lt; _MENU_ПРОДУКТ = P({1&lt;_MENU_СОРТИРОВКА ={$(=Concat('['&amp;[_MENU_СОРТИРОВКА]&amp;']',','))}&gt;} )&gt;} _MENU_ПРОДУКТ ), _MENU_ПРОДУКТ,_MENU_СОРТИРОВКА)</P> </PRE><P></P><P>Sort Formula is:</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_15120345113987787 jive_text_macro" jivemacro_uid="_15120345113987787"> <P>Only({1&lt; _MENU_ПРОДУКТ = P({1&lt;_MENU_СОРТИРОВКА ={$(=Concat('['&amp;[_MENU_СОРТИРОВКА]&amp;']',','))}&gt;} )&gt;} _MENU_ПРОДУКТ )</P> </PRE><P></P><P>Now menu looks like here:</P><P><IMG alt="_1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/185221__1.PNG" style="height: auto;" /></P><P></P><P>But the product "КФЛ" <SPAN style="font-size: 13.3333px;">should be on the first like</SPAN>:</P><P></P><P><IMG alt="_2.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/185228__2.PNG" style="height: auto;" /></P><P>I just need Original Load Order <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Please help!</P><P></P><P>Thanks in advance!!!</P><P></P><P>P.S.: demo app in attachment...</P></BODY></HTML> Thu, 30 Nov 2017 09:42:32 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimention-Sort-Order-Original/m-p/1402617#M424994 lylererger 2017-11-30T09:42:32Z Re: Calculated Dimention/Sort Order/Original https://community.qlik.com/t5/QlikView/Calculated-Dimention-Sort-Order-Original/m-p/1402618#M424995 <HTML><HEAD></HEAD><BODY><P>I don't have access to open your file, But can you try with "Load Order"checked in sort tab for Product?</P></BODY></HTML> Thu, 30 Nov 2017 09:48:15 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimention-Sort-Order-Original/m-p/1402618#M424995 Anil_Babu_Samineni 2017-11-30T09:48:15Z Re: Calculated Dimention/Sort Order/Original https://community.qlik.com/t5/QlikView/Calculated-Dimention-Sort-Order-Original/m-p/1402619#M424996 <HTML><HEAD></HEAD><BODY><P>It is not working</P></BODY></HTML> Thu, 30 Nov 2017 10:11:48 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimention-Sort-Order-Original/m-p/1402619#M424996 lylererger 2017-11-30T10:11:48Z Re: Calculated Dimention/Sort Order/Original https://community.qlik.com/t5/QlikView/Calculated-Dimention-Sort-Order-Original/m-p/1402620#M424997 <HTML><HEAD></HEAD><BODY><P>PFA</P></BODY></HTML> Thu, 30 Nov 2017 11:56:54 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimention-Sort-Order-Original/m-p/1402620#M424997 Anil_Babu_Samineni 2017-11-30T11:56:54Z Re: Calculated Dimention/Sort Order/Original https://community.qlik.com/t5/QlikView/Calculated-Dimention-Sort-Order-Original/m-p/1402621#M424998 <HTML><HEAD></HEAD><BODY><P>Thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 30 Nov 2017 12:30:32 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimention-Sort-Order-Original/m-p/1402621#M424998 lylererger 2017-11-30T12:30:32Z