https://community.qlik.com/t5/QlikView/Alternate-State-and-Table-Expression-Total/m-p/1863881#M1216237 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Table1.JPG" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/67485i61470132C512100F/image-size/medium?v=v2&amp;px=400" role="button" title="Table1.JPG" alt="Table1.JPG" /></span></P> <P> </P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Totale.jpg" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/67484i1E1728FA3D1FD3AD/image-size/medium?v=v2&amp;px=400" role="button" title="Totale.jpg" alt="Totale.jpg" /></span></P> <P> </P> <P> </P> <P>Hi I have an issue with alternate state.</P> <P>I need to show the table expression total on the top of the table (not pivot) but:</P> <P>- if I use the formula Only({State1}ItemPrice)*Quantity&nbsp; it does not show the expression total on the top of the table (blank)</P> <P>- if I use the formula Sum({State1}ItemPrice)*Quantity in the expression total it shows the sum of ALL the ItemPrice without consider the dimensions selected.</P> <P>I think I need the equivalent of the $ for the set modifiers... Is there anything I can do?</P> <P>Thanks</P> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 26 Nov 2021 09:12:47 GMT mmilani12 2021-11-26T09:12:47Z https://community.qlik.com/t5/QlikView/Alternate-State-and-Table-Expression-Total/m-p/1863881#M1216237 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Table1.JPG" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/67485i61470132C512100F/image-size/medium?v=v2&amp;px=400" role="button" title="Table1.JPG" alt="Table1.JPG" /></span></P> <P> </P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Totale.jpg" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/67484i1E1728FA3D1FD3AD/image-size/medium?v=v2&amp;px=400" role="button" title="Totale.jpg" alt="Totale.jpg" /></span></P> <P> </P> <P> </P> <P>Hi I have an issue with alternate state.</P> <P>I need to show the table expression total on the top of the table (not pivot) but:</P> <P>- if I use the formula Only({State1}ItemPrice)*Quantity&nbsp; it does not show the expression total on the top of the table (blank)</P> <P>- if I use the formula Sum({State1}ItemPrice)*Quantity in the expression total it shows the sum of ALL the ItemPrice without consider the dimensions selected.</P> <P>I think I need the equivalent of the $ for the set modifiers... Is there anything I can do?</P> <P>Thanks</P> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 26 Nov 2021 09:12:47 GMT https://community.qlik.com/t5/QlikView/Alternate-State-and-Table-Expression-Total/m-p/1863881#M1216237 mmilani12 2021-11-26T09:12:47Z https://community.qlik.com/t5/QlikView/Alternate-State-and-Table-Expression-Total/m-p/1863950#M1216239 <P><SPAN>It can also be used to tie a measure to a&nbsp;</SPAN><EM>state</EM><SPAN>&nbsp;in the&nbsp;</SPAN><EM>expression</EM><SPAN>. To find the&nbsp;</SPAN><EM>total</EM><SPAN>&nbsp;value in State1 the syntax would be: sum({State1}Value).</SPAN></P> <P>&nbsp;</P> <P><A href="https://www.njmcdirect.tips/" target="_self"><SPAN>NJMCDirect Ticket Pay</SPAN></A></P> Fri, 26 Nov 2021 12:08:24 GMT https://community.qlik.com/t5/QlikView/Alternate-State-and-Table-Expression-Total/m-p/1863950#M1216239 Vargas85 2021-11-26T12:08:24Z