Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a formula like so:
sum(
{<[Belegfluss.Zeitspanne Monate] = {"<=$(=vIntervallMonate)"}, [CE11000.Verkaufsbüro] -= [Belegfluss.Verkaufsbüro], [Belegfluss.Verkaufsbüro] = {"*"}>}
[CE11000.Umsatz]
)
The first two filters work fine, but [Belegfluss.Verkaufsbüro] = {"*"} has no effect. Yet I I select all values in the table in the worksheet, I get the correct number.
How can I tell qlik sense to mimic that behaviour?
Hi
Are you trying to select everything (all) with[Belegfluss.Verkaufsbüro] = {"*"}
if so it should be [Belegfluss.Verkaufsbüro] =,
(no selection)
So your sum would be this
sum({<[Belegfluss.Verkaufsbüro] =, [Belegfluss.Zeitspanne Monate] = {"<=$(=vIntervallMonate)"}, [CE11000.Verkaufsbüro] -= [Belegfluss.Verkaufsbüro]>}[CE11000.Umsatz])
I hope this helps
Tracey