https://community.qlik.com/t5/QlikView/Expression-total-monthly-number-excluding-a-dimension/m-p/1721644#M723466 <P>Hi,&nbsp;</P><P>Below is an extract from 12 months of data I have in QlikView:</P><P>Month&nbsp; &nbsp; &nbsp;Temp count&nbsp; &nbsp; &nbsp;Rag Status</P><P>May&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;46&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Red</P><P>May&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;283&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Amber</P><P>May&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Green</P><P>I want to be able to produce a stacked bar chart that shows as a percentage of the total temp count for each month.&nbsp; But I'm struggling to work out how to get the total temp count as an expression by month.</P><P>e.g. what I want is&nbsp;</P><P>Month&nbsp; &nbsp; &nbsp;Temp count&nbsp; &nbsp; Rag status&nbsp; &nbsp; &nbsp; <STRONG>Total temp count</STRONG>&nbsp; &nbsp; %</P><P>May&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 46&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Red&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <STRONG>1330</STRONG>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4%</P><P>May&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 283&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Amber&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <STRONG>1330</STRONG>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 21%</P><P>May&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Green&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <STRONG>1330</STRONG>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 75%&nbsp;</P><P>&nbsp;</P><P>Could you please help me with the total temp count which is a total of the temp count for the month?</P> Wed, 25 Nov 2020 16:16:04 GMT tinapullen1 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Expression-total-monthly-number-excluding-a-dimension/m-p/1721644#M723466 <P>Hi,&nbsp;</P><P>Below is an extract from 12 months of data I have in QlikView:</P><P>Month&nbsp; &nbsp; &nbsp;Temp count&nbsp; &nbsp; &nbsp;Rag Status</P><P>May&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;46&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Red</P><P>May&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;283&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Amber</P><P>May&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Green</P><P>I want to be able to produce a stacked bar chart that shows as a percentage of the total temp count for each month.&nbsp; But I'm struggling to work out how to get the total temp count as an expression by month.</P><P>e.g. what I want is&nbsp;</P><P>Month&nbsp; &nbsp; &nbsp;Temp count&nbsp; &nbsp; Rag status&nbsp; &nbsp; &nbsp; <STRONG>Total temp count</STRONG>&nbsp; &nbsp; %</P><P>May&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 46&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Red&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <STRONG>1330</STRONG>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4%</P><P>May&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 283&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Amber&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <STRONG>1330</STRONG>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 21%</P><P>May&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Green&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <STRONG>1330</STRONG>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 75%&nbsp;</P><P>&nbsp;</P><P>Could you please help me with the total temp count which is a total of the temp count for the month?</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Expression-total-monthly-number-excluding-a-dimension/m-p/1721644#M723466 tinapullen1 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Expression-total-monthly-number-excluding-a-dimension/m-p/1721646#M723467 <P>Try like:</P><P>Count( <STRONG>Total</STRONG> [Temp count])</P> Wed, 24 Jun 2020 10:17:28 GMT https://community.qlik.com/t5/QlikView/Expression-total-monthly-number-excluding-a-dimension/m-p/1721646#M723467 tresB 2020-06-24T10:17:28Z https://community.qlik.com/t5/QlikView/Expression-total-monthly-number-excluding-a-dimension/m-p/1721650#M723468 <P>Thank you for replying but this just gives me 0 on all the total temp count lines?</P> Wed, 24 Jun 2020 10:24:43 GMT https://community.qlik.com/t5/QlikView/Expression-total-monthly-number-excluding-a-dimension/m-p/1721650#M723468 tinapullen1 2020-06-24T10:24:43Z https://community.qlik.com/t5/QlikView/Expression-total-monthly-number-excluding-a-dimension/m-p/1721651#M723469 <P>If the field name is right, the expression should work. Could you share a screen shot of the field and chart output?</P> Wed, 24 Jun 2020 10:28:57 GMT https://community.qlik.com/t5/QlikView/Expression-total-monthly-number-excluding-a-dimension/m-p/1721651#M723469 tresB 2020-06-24T10:28:57Z https://community.qlik.com/t5/QlikView/Expression-total-monthly-number-excluding-a-dimension/m-p/1721652#M723470 <P>Almost there I think!&nbsp; The temp count is an expression....count[Incident type]</P><P>So I have done the new expression as count(Total[incident type] which has given me a total of all the incident types in the data set (total of 25338), now I would only like this total to be the month total (e.g. May = 1330) as I have 12 months data&nbsp;</P> Wed, 24 Jun 2020 10:31:04 GMT https://community.qlik.com/t5/QlikView/Expression-total-monthly-number-excluding-a-dimension/m-p/1721652#M723470 tinapullen1 2020-06-24T10:31:04Z https://community.qlik.com/t5/QlikView/Expression-total-monthly-number-excluding-a-dimension/m-p/1721654#M723474 <P>Hi, I have attached example - so where I have highlighted yellow (May data) I would like to see the number 1330, for June I have circled I would like to see 1346&nbsp;</P> Wed, 24 Jun 2020 10:37:22 GMT https://community.qlik.com/t5/QlikView/Expression-total-monthly-number-excluding-a-dimension/m-p/1721654#M723474 tinapullen1 2020-06-24T10:37:22Z https://community.qlik.com/t5/QlikView/Expression-total-monthly-number-excluding-a-dimension/m-p/1721655#M723478 <P>This?</P><P><SPAN>count(<STRONG>Total &lt;MonthField&gt;</STRONG> [incident type]&nbsp;)</SPAN></P> Wed, 24 Jun 2020 10:37:27 GMT https://community.qlik.com/t5/QlikView/Expression-total-monthly-number-excluding-a-dimension/m-p/1721655#M723478 tresB 2020-06-24T10:37:27Z https://community.qlik.com/t5/QlikView/Expression-total-monthly-number-excluding-a-dimension/m-p/1721656#M723481 <P>Brilliant!&nbsp; Thank you so much</P> Wed, 24 Jun 2020 10:40:24 GMT https://community.qlik.com/t5/QlikView/Expression-total-monthly-number-excluding-a-dimension/m-p/1721656#M723481 tinapullen1 2020-06-24T10:40:24Z