topic Re: Set analysis issue in value in QlikView

Set analysis issue in value

Mon, 17 Nov 2014 16:34:24 GMT

Ideally the both the following function should return the same

=sum( {$} Invoice_Quantity*Item_Price)

=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 — Mon, 17 Nov 2014 17:31:24 GMT

$ 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!

Mon, 17 Nov 2014 18:31:25 GMT

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)