Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
georgegv
Contributor II
Contributor II

Set analysis - Qliksense

Hi

 

The below is my set Analysis syntax but I am getting no return/ Output.

 

=sum({$<[Owner Name]={[Anthea Botes],Month=,}>}Hours)

Any suggestions

 

Regards

1 Solution

Accepted Solutions
marcus_malinow
Partner - Specialist III
Partner - Specialist III

Ok, I'm assuming you want the sum of hours for Anthea Botes, disregarding any selection n Month. In which case, try this:

sum({$<[Owner Name]={'Anthea Botes'},Month=>} Hours)

 

View solution in original post

4 Replies
marcus_malinow
Partner - Specialist III
Partner - Specialist III

Ok, I'm assuming you want the sum of hours for Anthea Botes, disregarding any selection n Month. In which case, try this:

sum({$<[Owner Name]={'Anthea Botes'},Month=>} Hours)

 

marcus_malinow
Partner - Specialist III
Partner - Specialist III

Also, you may find this useful in order to avoid syntax issues in your expressions:

Set Analysis Wizard

ChiragPradhan
Creator II
Creator II

Hi,

Use this expression - 

Sum({$<[Owner Name]={'Anthea Botes'}, Month=>}Hours)

Regards,

Chirag

raman_rastogi
Partner - Creator III
Partner - Creator III

try this

=sum({$<[Owner Name]={"Anthea Botes"},Month=}>}Hours)