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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Jahan
Contributor
Contributor

GetCurrentSelections() is not working selection of all month

Hi Every One,
I am facing some issue regarding GetCurrentSelections(). Let me explain my scenario first.

I used GetCurrentSelections()  for selection of current Month it is working correctly. it is working for multiple months as well but when I select all the month from filter  condition to 'NOT aug , Sep,Oct,Nov ,Dec' and my dashboard values disappeared.

Current month (July)

In first screen I selected all month -1 ( Feb to July). It is working.  

Jahan_0-1690629217963.png

In second screen I selected all month  ( Jan to July). It is not working.  

Jahan_1-1690629351639.png

There is no issue in Jan if I select Jan to June , It is working but when I select July dashbaord showing zero values

 

Labels (7)
3 Replies
Or
MVP
MVP

GetCurrentSelections() takes a parameter for the maximum number of values to list. By default, this is six. In your case, you would presumably want to use 12.

https://help.qlik.com/en-US/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/ChartFunctions/Fi...

 

Jahan
Contributor
Contributor
Author

May be you are right but this issue is not selection of six element. It was in YTD March,April ,May and  June as well. Like in month of june If I selected Jan to June it was showing error

marcus_sommer

I'm not sure but I doubt that there are direct customizable options to define how many selected values are displayable before the logic reverted to show NOT ...

Beside this these functions aren't mandatory needed respectively suitable within the most scenarios else often it's simpler just to use: count(distinct FIELD) or concat(distinct FIELD, ',') to get the number and values of the selected items. And also these approaches are often not needed because these queries are applied within a set analysis and could be there replaced with: p() respectively e().