topic Dynamic Readout in QlikView https://community.qlik.com/t5/QlikView/Dynamic-Readout/m-p/778053#M275799 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have searched the forum but couldn't find an answer to my question maybe you can help me out: </P><P></P><P>I have loaded a database table and one of the fields i'm loading contains values like Books, EMail, Newspapers:</P><P></P><P>MyValue:</P><P>Books,</P><P>EMail,</P><P>Newspapers</P><P></P><P>Now i want to count the sales for each of the different Books, EMail, Newspapers but i don't want to use an if statement in my chart like:</P><P></P><P>If(MyValue='Books', count(sales))</P><P></P><P>I need it dynamically! In case i will have assigned a new MyValue like Magazines the sales should be automatically counted for this new value and shown.</P><P></P><P>Hope my question is clear. In case you have any questions please let me know.</P><P></P><P>Best</P><P>Harry </P></BODY></HTML> Thu, 06 Nov 2014 08:42:01 GMT 2014-11-06T08:42:01Z Dynamic Readout https://community.qlik.com/t5/QlikView/Dynamic-Readout/m-p/778053#M275799 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have searched the forum but couldn't find an answer to my question maybe you can help me out: </P><P></P><P>I have loaded a database table and one of the fields i'm loading contains values like Books, EMail, Newspapers:</P><P></P><P>MyValue:</P><P>Books,</P><P>EMail,</P><P>Newspapers</P><P></P><P>Now i want to count the sales for each of the different Books, EMail, Newspapers but i don't want to use an if statement in my chart like:</P><P></P><P>If(MyValue='Books', count(sales))</P><P></P><P>I need it dynamically! In case i will have assigned a new MyValue like Magazines the sales should be automatically counted for this new value and shown.</P><P></P><P>Hope my question is clear. In case you have any questions please let me know.</P><P></P><P>Best</P><P>Harry </P></BODY></HTML> Thu, 06 Nov 2014 08:42:01 GMT https://community.qlik.com/t5/QlikView/Dynamic-Readout/m-p/778053#M275799 2014-11-06T08:42:01Z Re: Dynamic Readout https://community.qlik.com/t5/QlikView/Dynamic-Readout/m-p/778054#M275800 <HTML><HEAD></HEAD><BODY><P>You can use MyValue as dimension and your expression will simple be Sum(Sales), this value vill be automatically splitted into all the values of your MyValue field.</P><P></P><P>Let me know</P></BODY></HTML> Thu, 06 Nov 2014 08:45:08 GMT https://community.qlik.com/t5/QlikView/Dynamic-Readout/m-p/778054#M275800 alexandros17 2014-11-06T08:45:08Z