Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
davyqliks
Specialist
Specialist

Select All in dimension using set analysis

Hi,

I am trying to select all in a dimension using set analysis in my expression:

For Internal Customers in the below, i would like to  select all, i thought '*' may work.

=Num( sum( {< Month = {'Jan','Feb'},
[Year] = {"$(=max(Year))"} ,
Company = {'ppepsi'},
[Internal Customers] = {'*'}

>}
[GBP_Price]),'$(v.Format.Int.0dp)')

 

 

How can al all selection be made in set please?

Thank you

 

Labels (3)
1 Solution

Accepted Solutions
joaopaulo_delco
Partner - Creator III
Partner - Creator III

Hi @davyqliks !

Try to change this 

[Internal Customers] = {'*'}

to 

[Internal Customers] = {"*"}

Help users find answers! Don't forget to mark a solution that worked for you!

View solution in original post

1 Reply
joaopaulo_delco
Partner - Creator III
Partner - Creator III

Hi @davyqliks !

Try to change this 

[Internal Customers] = {'*'}

to 

[Internal Customers] = {"*"}

Help users find answers! Don't forget to mark a solution that worked for you!