topic Re: Set analysis expression issue in QlikView

Set analysis expression issue

cliff_clayman — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I am trying to use the following in an expression to populate a field in a chart and it is not returning a value:

=IF([TEH] = 'A',SUM({$<[Month] = {'M1'}>} [TotalEmpl]))

This part does return the value when used outside of the chart

=SUM({$<[Month] = {'M1'}>} [TotalEmpl])

What am I doing wrong?

Re: Set analysis expression issue

sunny_talwar — Fri, 18 Mar 2016 08:46:48 GMT

What about this:

=Sum({$<[Month] = {'M1'}, TEH = {'A'}>} [TotalEmpl])

Re: Set analysis expression issue

Kushal_Chawda — Fri, 18 Mar 2016 08:47:56 GMT

try this if you want to display the result for [TEH]= A

SUM({$<[Month] = {'M1'}, [TEH]={'A'}>} [TotalEmpl])

Re: Set analysis expression issue

Kushal_Chawda — Fri, 18 Mar 2016 08:49:27 GMT

If it's not working please provide more details

which chart?

what are dimesion?

what are expression?

Re: Set analysis expression issue

Anonymous — Fri, 18 Mar 2016 08:50:13 GMT

If you selects A from [TEH], probably your will get the value of your expression..

Best part is always use SET Analysis, Sunny Thave already suggested you same

Re: Set analysis expression issue

cliff_clayman — Fri, 18 Mar 2016 14:45:34 GMT

=Sum({$<[Month] = {'M1'}, TEH = {'A'}>} [TotalEmpl])

This still returns a value of 0. When I apply this to a simple textbox outside of the chart, I get the correct value. I'm not sure what is wrong. What other information can I provide that will help? I am very new to all of this.

Re: Set analysis expression issue

sunny_talwar — Fri, 18 Mar 2016 15:51:03 GMT

Is it possible to share a sample?

Re: Set analysis expression issue

Kushal_Chawda — Sat, 19 Mar 2016 05:03:02 GMT

I think Your period is not associated with MCR heading. See the screenshot.

When I am selecting any MCR Heading. Period is blank

Also I checked your data model which involves many synthetic keys. Try to optimize your data model.

Re: Set analysis expression issue

cliff_clayman — Mon, 21 Mar 2016 14:18:52 GMT

$(=sum({$<[Period] = {'P2'}>} [HC]))

This produces the correct value.