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: 
orangebloss
Creator
Creator

Show Measure if selected in filter

I'm wanting to show a value in a chart if it is selected in the filter or if nothing is selected.

I have tired using:

(GetFieldSelections(SevenDayTaskCompletionTimeStatus) ='Complete - No Due Date') or GetSelectedCount(SevenDayTaskCompletionTimeStatus)=0

and

wildmatch(GetFieldSelections(SevenDayTaskCompletionTimeStatus),'Complete - No Due Date'')

or GetSelectedCount(SevenDayTaskCompletionTimeStatus)=0

These work if only one option in the filter is selected, but if I wanted to show both 'Complete' and 'Complete - No Due Date' then it returns an error

:

 
 

Screenshot 2025-02-14 112600.png

 

 

 

Advice on how to get it to show if it's selected appreciated!

Labels (3)
1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

Try this 

If(

    GetSelectedCount(SevenDayTaskCompletionTimeStatus) = 0 

    OR WildMatch(Concat(SevenDayTaskCompletionTimeStatus, '|'), '*Complete*'), 

    YourMeasure

)

View solution in original post

3 Replies
MatheusC
Specialist II
Specialist II

Hi, 

@orangebloss, For me this solution worked well, test it in your case.


if(Concat(DISTINCT YourField, ', ') = Concat({< YourField *= {'Value1', 'Value2'}>}DISTINCT YourField, ', '),1,0)

- Regads, Matheus

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
Chanty4u
MVP
MVP

Try this 

If(

    GetSelectedCount(SevenDayTaskCompletionTimeStatus) = 0 

    OR WildMatch(Concat(SevenDayTaskCompletionTimeStatus, '|'), '*Complete*'), 

    YourMeasure

)

orangebloss
Creator
Creator
Author

Absolutely perfect! Thanks!