topic Dynamic Measures in QlikView https://community.qlik.com/t5/QlikView/Dynamic-Measures/m-p/450864#M563437 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to create a stacked graph to check the region wise sales pipeline.</P><P></P><P>Dimension: Region</P><P>Expression: Sum of amount of deals (both sold and pipeline)</P><P></P><P>I want to keep the graph to show just Sold deals at the beginning. And give the user an option to add a pipeline of his choice (there are 3 stages in pipeline). </P><P>If a user wants to see the pipeline of say stage 1, he will choose the stage and it gets stacked over the graph for sold. He can add all stages to the the graph to be stacked with sold, or select any of the stages.</P><P></P><P>Any help on this will be highly appreciated.</P></BODY></HTML> Tue, 19 Feb 2013 16:41:48 GMT bhaskarsharma03 2013-02-19T16:41:48Z Dynamic Measures https://community.qlik.com/t5/QlikView/Dynamic-Measures/m-p/450864#M563437 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to create a stacked graph to check the region wise sales pipeline.</P><P></P><P>Dimension: Region</P><P>Expression: Sum of amount of deals (both sold and pipeline)</P><P></P><P>I want to keep the graph to show just Sold deals at the beginning. And give the user an option to add a pipeline of his choice (there are 3 stages in pipeline). </P><P>If a user wants to see the pipeline of say stage 1, he will choose the stage and it gets stacked over the graph for sold. He can add all stages to the the graph to be stacked with sold, or select any of the stages.</P><P></P><P>Any help on this will be highly appreciated.</P></BODY></HTML> Tue, 19 Feb 2013 16:41:48 GMT https://community.qlik.com/t5/QlikView/Dynamic-Measures/m-p/450864#M563437 bhaskarsharma03 2013-02-19T16:41:48Z Re: Dynamic Measures https://community.qlik.com/t5/QlikView/Dynamic-Measures/m-p/450865#M563438 <HTML><HEAD></HEAD><BODY><P>Solved <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 20 Feb 2013 06:49:53 GMT https://community.qlik.com/t5/QlikView/Dynamic-Measures/m-p/450865#M563438 bhaskarsharma03 2013-02-20T06:49:53Z