Set analysis issue in value

[#1]

Ideally the both the following function should return the same

=sum( {$} Invoice_Quantity*Item_Price)

or

=sum( Invoice_Quantity*Item_Price)

But it showing different values and with $ it showing the total value. Fail to understand why ?

I am using different state in document and the control where this function is placed using the inherited state of the sheet.

[Gysbert_Wassenaar]

$ is for the default state. If you're using alternate states then the default state is not necessarily the same as the inherited state of the object. See this blog post: Set Analysis & Alternate States – Quick Tip » The Qlik Board!

[#3 · Accepted solution]

Thanks. I figure that out. so instead of $ or any its variant need to use the state name.

=sum( {state_name} Invoice_Quantity*Item_Price)