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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
awp2020
Contributor III
Contributor III

filter pane and selected values

Hello,

I have a filter pane to select a period. How to get selected  values with set analysis?

awp2020_0-1649343849653.png

 

 

Labels (1)
1 Solution

Accepted Solutions
awp2020
Contributor III
Contributor III
Author

Hello,

I found how to get values.

I declare a variable for the first value :

vDate_start = SubField(GetFieldSelections (PERIOD),',',1)

and for the 2nd value :

vDate_end = Trim(SubField(GetFieldSelections (PERIOD),',',2))

Be careful, there was a space in front, so I used the trim function to remove it.

I can use them with set analysis :

{<PERIOD]={'$(vDate_end)'}>}

View solution in original post

1 Reply
awp2020
Contributor III
Contributor III
Author

Hello,

I found how to get values.

I declare a variable for the first value :

vDate_start = SubField(GetFieldSelections (PERIOD),',',1)

and for the 2nd value :

vDate_end = Trim(SubField(GetFieldSelections (PERIOD),',',2))

Be careful, there was a space in front, so I used the trim function to remove it.

I can use them with set analysis :

{<PERIOD]={'$(vDate_end)'}>}