Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
$ 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!
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)