Combine Two Statement

[prabunakil]

Hi, can i check how to combine this two expression become one expression for my qlikview pivot table expression.

=Sum(if([Bill Type]='LG3' and [KSCHL]='ZPR0',[KONV_KWERT]*-1))

=Sum(if([Bill Type]='LF2' and [KSCHL]='ZRBP',[KONV_KWERT]*-1))

I am new to qlikview, hope someone to assist.

[Anil_Babu_Samineni]

May be this?

Sum({<[Bill Type] = {'LG3', 'Lf2'}, KSCHL = {'ZPRO','ZRBP'}>} (KONV_KWERT*-1))

[Chanty4u]

Try this

Anil Case sensitive

Sum({<[Bill Type]={'LG3','LF2'},KSCHL={'ZPRO','ZRBP'}>}(KONV_KWERT*-1))

[mdmukramali · Accepted solution]

Hi,

You can use Set Analysis :

=(Sum({<[Bill Type]={'LG3','LF2'},KSCHL={'ZPR0','ZRBP'}>}[KONV_KWERT])*-1)

Thanks,

Mukram

[Anil_Babu_Samineni]

May be i forget to press Shift that case

[Chanty4u]

No issue bro   he will check  or some other way some one will the sollution

[prabunakil]

Thank you, is working fine now.

But i have another question now.

Can anyone know how come my gross wont show in details instead of lum sum. My sum total is correct but i need details.