Sum intersection

[martinr_]

Hello.

I have a question about the constraint on sums.
These query give me a result in SQL.

select sum(sales) from test where belegtyp='AB' and geschaeftsjahr=kdatum_geschaeftsjahr

What must it look like in QLIK? I always get 0.
Sum(TOTAL{<BELEGTYP={'AB'},GESCHAEFTSJAHR={"KDATUM_GESCHAEFTSJAHR"}>}SALES)

Thanks for your help.

[Somasundaram]

Try with this,

Sum({<BELEGTYP={'AB'},GESCHAEFTSJAHR={'KDATUM_GESCHAEFTSJAHR'}>}SALES)

[martinr_]

Hi,

I tried this, but both provide 0

Sum ({<BELEGTYP = { 'AB'}, GESCHAEFTSJAHR = { 'KDATUM_GESCHAEFTSJAHR'}>} SALES)

Sum ({<BELEGTYP = { 'AB'}, GESCHAEFTSJAHR = { "KDATUM_GESCHAEFTSJAHR"}>} SALES)

[Somasundaram]

If possible can you share the qlik file?

[sunny_talwar]

May be you want kdatum_geschaeftsjahr to be in lower case

Sum({<BELEGTYP = {'AB'}, GESCHAEFTSJAHR ={"kdatum_geschaeftsjahr"}>} SALES)

[sunny_talwar]

Is kdatum_geschaeftsjahr another field or is that the value with GESCHAEFTSJAHR field?

[martinr_]

result is 0.

table see pic

[sunny_talwar]

Try this

Sum({<BELEGTYP = {'AB'}>} If(GESCHAEFTSJAHR = KDATUM_GESCHAEFTSJAHR, SALES))

[martinr_ · Accepted solution]

Thank you - is working 🙂

Nice Weekend !!!!

[sunny_talwar]

Super 🙂