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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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  ?