Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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
Specialist III
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
Specialist III
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
Specialist III
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)