Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
gerrycastellino
Creator III
Creator III

Set Expression with variable as set modifier

vMac_Rating                                                               count( {< [Mac Rating]={'$(vRating_List)'} >} [Mac Rating])

vRating_List0,1,2,3,4,5,6,7,8,9,10

How do I format my variable to be read into the set expression.

I have these as lines in an Excel file.

Gerry.

1 Solution

Accepted Solutions
tamilarasu
Champion
Champion

Hi Gerry,


Another solution,


count( {< [Mac Rating]={$(=vRating_List)} >} [Mac Rating])

View solution in original post

3 Replies
sunny_talwar

Try it without the single quotes:

Count({<[Mac Rating] = {$(vRating_List)}>} [Mac Rating])

tamilarasu
Champion
Champion

Hi Gerry,


Another solution,


count( {< [Mac Rating]={$(=vRating_List)} >} [Mac Rating])

gerrycastellino
Creator III
Creator III
Author

You are the greatest !