Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
carolin01
Luminary Alumni
Luminary Alumni

Qlik Sense Set Analysis

Hi,

I´m currently doing my fist test in Qlik Sense after I used Qlik View for several years as designer and developer. Now I would like to use a set analysis expression:

sum({$<OrderPhase_Desc = 'Bookings', FYear = {'2016'} >}NettAmount$(vCurrency))

The issue is that it bring just the same value as this expression:

sum({$<OrderPhase_Desc = 'Bookings', FYear = {'2017'} >}NettAmount$(vCurrency))

Qlik Sense doesn´t show that the expression is not correct. The indicated value is 4 Million no matter if I use the one or the other expression and that value is neither correct for Year 2016 nor for 2017. It also doesn´t change if I delete the FYear from the set analysis expression. What do I do wrong? I also tried it in different objects.

Many thanks in advance!

1 Solution

Accepted Solutions
eduardo_sommer
Partner - Specialist
Partner - Specialist

Hi, Carolin

Your expression is missing the brackets for the OrderPhase_Desc OrderPhase_Desc = {'Bookings'}

Did this help you?

Eduardo

View solution in original post

3 Replies
eduardo_sommer
Partner - Specialist
Partner - Specialist

Hi, Carolin

Your expression is missing the brackets for the OrderPhase_Desc OrderPhase_Desc = {'Bookings'}

Did this help you?

Eduardo

sunny_talwar

I think you missed the curly brackets around Booking and misplaced the $

Sum({$<OrderPhase_Desc = {'Bookings'}, FYear = {'2016'} >}NettAmount$(vCurrency))

carolin01
Luminary Alumni
Luminary Alumni
Author

You are both right! So stupid that I didn´t see that