Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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

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

I have resolve my issue with "ONLY"

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

Thanks guys

3 Replies
MVP
MVP

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

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

Not applicable

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

I have resolve my issue with "ONLY"

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

Thanks guys

MVP
MVP

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

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

Community Browser