Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Set analysis expression shouldnt change when selecting monthyear

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

Tags (3)
1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

Re: Set analysis expression shouldnt change when selecting monthyear

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

View solution in original post

3 Replies
Highlighted
Creator III
Creator III

Re: Set analysis expression shouldnt change when selecting monthyear

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

View solution in original post

Highlighted
Not applicable

Re: Set analysis expression shouldnt change when selecting monthyear

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.

Highlighted
Creator III
Creator III

Re: Set analysis expression shouldnt change when selecting monthyear

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