topic Re: Combine Two Statement in QlikView

Combine Two Statement

prabunakil — Thu, 14 Sep 2017 02:34:10 GMT

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 — Thu, 14 Sep 2017 09:44:37 GMT

May be this?

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

Chanty4u — Thu, 14 Sep 2017 09:46:21 GMT

Try this

Anil Case sensitive

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

mdmukramali — Thu, 14 Sep 2017 09:46:35 GMT

Hi,

You can use Set Analysis :

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

Thanks,

Mukram

Anil_Babu_Samineni — Thu, 14 Sep 2017 09:47:50 GMT

May be i forget to press Shift that case

Chanty4u — Thu, 14 Sep 2017 09:50:23 GMT

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

prabunakil — Fri, 15 Sep 2017 08:09:33 GMT

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.