Expression not ignoring selections

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

Hi all,

I have an expression in the attached QVW that even though in my set analysis i am telling it to ignore selections on Year and Period it doesnt seem to be ignoring them.

I have the same expression in the chart and text box and both are doing the same thing.

The expression is..

=Sum(Aggr(

(((sum({<$(vDatePeriod),Currency={'USD'},ForecastVersion=, Manufactured_Flag={0}>}[Latest Cost])

(1+sum({<$(vDatePeriod),ForecastVersion=,Currency={'USD'}>}[Freight %])+sum({<$(vDatePeriod),ForecastVersion=,Currency={'USD'}>}[Duty %])+sum({<$(vDatePeriod),ForecastVersion=,Currency={'USD'}>}[Demurrage %])))

sum({<$(vDatePeriod),ForecastVersion=, Currency={'USD'},Manufactured_Flag={0}>} [Sales Volume]))

((((sum({<$(vDatePeriod),ForecastVersion=, Currency={'USD'},Manufactured_Flag={0}>}[Latest Cost])

(1+sum({<$(vDatePeriod),ForecastVersion=, Currency={'USD'}>}[Freight %])+sum({<$(vDatePeriod),ForecastVersion=, Currency={'USD'}>}[Duty %])+sum({<$(vDatePeriod),ForecastVersion=, Currency={'USD'}>}[Demurrage %])))

sum({<$(vDatePeriod),ForecastVersion=, Currency={'USD'},Manufactured_Flag={0}>} [Sales Volume]))))

(1.3

only({<$(vDatePeriod),ForecastVersion=>}FX_Rate))),

SubCat, SubCat1, Item,[Customer Name],Sales_Counter))

The variable vDatePeriod contains the Year=,Period= and ive also tried it without using the variable but i get the same result.

If you clear all selections, you will see that the value in the chart and text box is -210171, this is the correct value that i want to display when any Year and Period is selected.

Can anyone spot anything that i am doing wrong?

Re: Expression not ignoring selections

Gysbert_Wassenaar — Fri, 20 Jul 2018 16:38:33 GMT

Sum(Aggr

That first sum doesn't contain a set modifier to make it ignore selections. Try Sum( {<Year,Period> } Aggr( ... etc

Re: Expression not ignoring selections

hopkinsc — Fri, 20 Jul 2018 16:42:06 GMT

Damn! i completely forgot about the first sum!

Thanks!

topic Re: Expression not ignoring selections in QlikView

Expression not ignoring selections

Re: Expression not ignoring selections

Re: Expression not ignoring selections