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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Get the value with filter by variable without (SUM, COUNT, MAX)

Hello Everyone,

I have a table with a month number & month description (used to filter data)

NoMonths
1January
2Februar
3March
.....

In a variable I have the number of the month : (no selection = number of th current mont, >1 selection = max number).

=IF(GetSelectedCount(TIME_DESC)1,Month(Today()),IF(GetSelectedCount(TIME_DESC)>1,Max(TIME_MONTHUM),TIME_MONTHUM))

But I need to have the in a other or same variable the description of the month number

Something like this : (TIME_MONTHUM=$(=vPeriod),TIME_DESC)

How to get the value with filter (without any SUM, COUNT)

Best regards

1 Solution

Accepted Solutions
Not applicable
Author

I have resolve my issue with "ONLY"

only({$<DashboardID={$(vDashboardIDForced)}>}DashboardNameFR_DDB)

Thanks guys

View solution in original post

3 Replies
sunny_talwar
MVP
MVP

I don't think i understand your questions. Do you mind re-explaining what you trying to get?

Not applicable
Author

I have resolve my issue with "ONLY"

only({$<DashboardID={$(vDashboardIDForced)}>}DashboardNameFR_DDB)

Thanks guys

sunny_talwar
MVP
MVP

Awesome, I am glad you got it working. Please close this thread by marking your own answer as correct