topic Re: Set analysis - ignore selection doesn't work in QlikView

Set analysis - ignore selection doesn't work

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

Hello

I have a filter PreviousMonth which gives me the Date range 2019-02-01 to 2019-02-28

However I need to make an exception to ignore this in an expression in order to get the sum value for yesterday (2019-03-04), which is the same as max(Date) in my application

=sum({<PreviousMonth=, Date={"$(=max(Date))"}>}value)

This doesn't work, anyone know why? I only get the value for 2019-02-28 with the above expression.

I cannot use {1} either as that ignores everything, i need to only ignore PreviousMonth. Any help would be appreciated

Re: Set analysis - ignore selection doesn't work

agigliotti — Tue, 05 Mar 2019 08:47:04 GMT

you got it because of max(Date), why did you use it?
what about using: sum( {< PreviousMonth >} value )

Re: Set analysis - ignore selection doesn't work

pradosh_thakur — Tue, 05 Mar 2019 08:47:47 GMT

Where do you use this , if you use this ina text box/kpi it shall give you the correct answer. If in a table you need to tell us what are the dimensions.

Re: Set analysis - ignore selection doesn't work

joeallen — Tue, 05 Mar 2019 08:58:49 GMT

it's in a textbox without dimensions, it doesn't work...

Re: Set analysis - ignore selection doesn't work

mrybalko — Tue, 05 Mar 2019 09:18:54 GMT

@joeallen

Could you provide test qvw?

Re: Set analysis - ignore selection doesn't work

joeallen — Tue, 05 Mar 2019 11:44:08 GMT

@mrybalko

here is sample provided

Just to reiterate:

I want the expression to ignore "PreviousMonth", when it's active, i.e. set to Yes.

So I want it to show the sum value for max(date), which is 2019-03-04, which is 8156185.05

But it shows the value for 2019-02-28, which is 9610818.95, even if i have PreviousMonth= in the expression.

Re: Set analysis - ignore selection doesn't work

mrybalko — Tue, 05 Mar 2019 14:41:31 GMT

=sum({<PreviousMonth=,  Date={'$(=max({<PreviousMonth=>}Date))'}>}ValueEUR)

Re: Set analysis - ignore selection doesn't work

joeallen — Tue, 05 Mar 2019 14:48:28 GMT

thank you! i didnt know you had to write the ignore field inside the max function...