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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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!