Qlik Sense Set Analysis

[carolin01]

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!

[eduardo_sommer · Accepted solution]

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]

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