Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
flo2
Contributor III
Contributor III

Set analysis irrespective of any selections doesn't work

Hello 🙂 

Again one question about set analysis which is pretty tough currently for me ^^ 

I changed my set analysis to make it irrespective of any selections but it doesn't work as I expected. 
( i changed the $ to a 1 )
because when I select anything, the numbers in the graph change, and if I have understood well, the numbers should not change otherwise it would be  like if I used $ in the set analysis. 

I don't understand why, if someone has any clues to show me the path ^^ 

 My set analysis is 

count({1<[date_1]={">=$(startMonthActual)"}>*<[date_1]={"<=$(endMonthAcual)"}>}[Person]

So if I select other date not in the boundary, the shown value is 0 and when the date is in the boundary, the value decreases as if it was a responsive set analysis. 

Thanks a lot for reading  ! 

 

 

2 Replies
MayilVahanan

HI @flo2 

In order to avoid the selection , assign the {1} set analysis in both startMonthActual & endMonthAcual variables also.

Ex: startMonthActual = Min({1}Date)

count({1<[date_1]={">=$(startMonthActual)<=$(endMonthAcual)"}>}[Person]

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
flo2
Contributor III
Contributor III
Author

edit : Thanks a lot, i think it works as you said, can you confirm me if it looks good to you ?

I had this variable :

=MonthEnd(today(),-1)

And i make it work now with  set analysis as you said, =Min({1}MonthEnd(today(),-1))

And also for the variable monthStart i use the same set analysis =Min({1}MonthStart(today(),-1))

I use min in both cases because in all cases i am going to have just one value, so if use max or min it will be the same if i don't say trash

thanks

 

-----------------

Thanks a lot ! And sorry to ask a bit too much but i have hard times with set analysis 😁

I have the variable StartMonthActual with the folowing definition : =MonthStart(today(),1)

and if i have understood well i can't use function in set anlysis no... ? Maybe that's totally false what I say 😅

(i wonder because  I have also a second variable i use  for the same graph    :      =MonthStart(today(),2)
the goal is to have the month in two months )

and in the same archetype, i have variables to have the last 3 months.

What could i do to have MonthStart(today(),2) as variable as set analysis  ?