topic Re: Set analysis expression shouldnt change when selecting monthyear in QlikView

Set analysis expression shouldnt change when selecting monthyear

Fri, 20 Sep 2013 12:09:15 GMT

Hello

I have this expression:

=count({1<DimRaptorCustomer.CustomerID={'$(vCustomer)'},Date_CleanDato={">=$(=Date(Min(Date_CleanDato))) <= $(=Date(Max(Date_CleanDato)))", MonthYear=}>} DateKey)

It is supposed to count all dates where i have data.

*But when i select monthYear in listbox. It only count the month i choose. It should not do so! It should act like i have nothing selected

Re: Set analysis expression shouldnt change when selecting monthyear

somenathroy — Fri, 20 Sep 2013 12:20:25 GMT

use below exp:

=count({1<DimRaptorCustomer.CustomerID={'$(vCustomer)'},

Date_CleanDato={">=$(=Date(Min({1< MonthYear>}Date_CleanDato)))

<= $(=Date(Max({1< MonthYear>}Date_CleanDato)))", MonthYear=}>} DateKey)

Regards,

som

Re: Set analysis expression shouldnt change when selecting monthyear

Fri, 20 Sep 2013 12:29:07 GMT

Brilliant. Why doesnt my expression not work? can u explain?

What about this expression:

=Monthend(Max(Date_CleanDato)) - MonthStart(min(Date_CleanDato))

how do i do so its not affected by the same.

Re: Set analysis expression shouldnt change when selecting monthyear

somenathroy — Fri, 20 Sep 2013 12:46:38 GMT

You have disregarded the selection only from count function using set modifier 1. But it needs to be included within Min and Max function also. For that reason MonthYear selection did effect on Min(Date_CleanDato) or Max(Date_CleanDato). Hope you will find ans your next query your self.

Regards,

som