Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi, Carolin
Your expression is missing the brackets for the OrderPhase_Desc OrderPhase_Desc = {'Bookings'}
Did this help you?
Eduardo
Hi, Carolin
Your expression is missing the brackets for the OrderPhase_Desc OrderPhase_Desc = {'Bookings'}
Did this help you?
Eduardo
I think you missed the curly brackets around Booking and misplaced the $
Sum({$<OrderPhase_Desc = {'Bookings'}, FYear = {'2016'} >}NettAmount$(vCurrency))
You are both right! So stupid that I didn´t see that