topic Re: Do I need a Macro for this? in QlikView https://community.qlik.com/t5/QlikView/Do-I-need-a-Macro-for-this/m-p/378647#M572229 <HTML><HEAD></HEAD><BODY><P>That worked. Thanks a lot.</P></BODY></HTML> Mon, 20 Aug 2012 17:12:22 GMT 2012-08-20T17:12:22Z Do I need a Macro for this? https://community.qlik.com/t5/QlikView/Do-I-need-a-Macro-for-this/m-p/378645#M572227 <HTML><HEAD></HEAD><BODY><P>I have list of stores (40) in a list box. The document produces various charts (time trends) on the store level performances e.g. sales, complaints, returns, etc. So when i select a store, It will give me a line chart of sales in my sales chart and line chart of returns in my returns chart for that store. If i select multiple stores it will change the chart to aggregate performance of the selected stores. This works fine and useful. However, now I want to produce a Sales chart for example in such a way that when selecting multiple stores instead of aggregating the sales it will add individual expression for the selected stores. e.g if i select 4 stores in the list box it should show me 4 lines in the chart representing individual performance of the selected store. Is it possible? What do i need to use? set analysis? Macro? or something else? Let me know if you need more explanation. </P></BODY></HTML> Thu, 16 Aug 2012 19:39:01 GMT https://community.qlik.com/t5/QlikView/Do-I-need-a-Macro-for-this/m-p/378645#M572227 2012-08-16T19:39:01Z Re: Do I need a Macro for this? https://community.qlik.com/t5/QlikView/Do-I-need-a-Macro-for-this/m-p/378646#M572228 <HTML><HEAD></HEAD><BODY><P>Samarth,</P><P></P><P>I think if you add store as a secondary dimesion in your chart you will be able to view 4 lines when you select 4 stores.</P><P></P><P>Hope it will help.</P></BODY></HTML> Thu, 16 Aug 2012 19:58:49 GMT https://community.qlik.com/t5/QlikView/Do-I-need-a-Macro-for-this/m-p/378646#M572228 bgerchikov 2012-08-16T19:58:49Z Re: Do I need a Macro for this? https://community.qlik.com/t5/QlikView/Do-I-need-a-Macro-for-this/m-p/378647#M572229 <HTML><HEAD></HEAD><BODY><P>That worked. Thanks a lot.</P></BODY></HTML> Mon, 20 Aug 2012 17:12:22 GMT https://community.qlik.com/t5/QlikView/Do-I-need-a-Macro-for-this/m-p/378647#M572229 2012-08-20T17:12:22Z