Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
VictorBoscaro
Contributor II
Contributor II

Filtering through properties of a dimension and not by the dimension it self

I have a table like this

VictorBoscaro_0-1622644406346.png

And I want to have a filter in my app that will have the name of the conselour (no_conselheiro) but when selected, the filter will be by those dates. The dates will be in a variable, and the variable will be used to filter a card.

How can I do this?

Labels (2)
1 Reply
brunobertels
Master
Master

Hi 

Here a first approach to test  

 

to get the list of possible date depending of selection made in Dim no_conseilheiro : 

If(GetselectedCount(no_conseilheiro ) >0 ,Concat(DISTINCT YourDateField,', '))

So now you may be able to create a variable with somethink like this 

Set vMyVariable = chr(39)&If(GetselectedCount(no_conseilheiro ) >0 ,Concat(DISTINCT YourDateField,', '))&chr(39)

it may listed the date like this : 

brunobertels_0-1622652204346.png

and then use your variable by calling it using $(vMyVariable) or $(=vMyVariable) to filter your card 

 

Hope it helps