topic Re: expression in QlikView

expression

adiarnon — Sun, 31 Jul 2016 15:09:52 GMT

hi,

i have this expression-

num(sum({<SO_DELIVERED_STATUS=,DELIVERY_STATUS={"Delivered on time"}>}&_Del_Measure1

in the field _Del_Measure1 i have the end of the expression

but when im using it i get - error in the expression

what can i do?

adi

Re: expression

vinieme12 — Sun, 31 Jul 2016 15:28:33 GMT

num(sum({<SO_DELIVERED_STATUS=,DELIVERY_STATUS={"Delivered on time"}>}_Del_Measure1))

You see the Red Opening brackets indicate that the function is yet to be closed.

Re: expression

trdandamudi — Sun, 31 Jul 2016 15:29:52 GMT

To get a better understanding can you please post a small sample...

Re: expression

MindaugasBacius — Sun, 31 Jul 2016 16:15:27 GMT

num(sum({<SO_DELIVERED_STATUS=,DELIVERY_STATUS={"Delivered on time"}>}&))_Del_Measure1

If you use only sum you will get the sum of the values in the field:

sum(&_Del_Measure1)

If you use inside the sum statement <{ Field = {"Value"}}> you will get the sum of the values where Field = Value. It's Set analysis. Try to search information in the community. It's plenty of blog posts.)

Re: expression

Anil_Babu_Samineni — Sun, 31 Jul 2016 16:50:09 GMT

&_Del_Measure1 -- Is that is Dimension or you want to show That value in &

Re: expression

adiarnon — Tue, 02 Aug 2016 07:45:48 GMT

I WANT TO BE MORE CLEAR-

hi,

i have 3 expression -

1.sum({<SO_DELIVERED_STATUS=,DELIVERY_STATUS={"Delivered on time"}>}QTY)

2.sum({<SO_DELIVERED_STATUS=,DELIVERY_STATUS={"Delivered on time"},Delivered= >}SALES)

3.sum({<SO_DELIVERED_STATUS=,DELIVERY_STATUS={"Delivered on time"},Delivered={'0'} >}SALES)

I HAVE A LIST BOX _Del_Measure1

_Del_Measure1

>}QTY)

,Delivered= >}SALES)

,Delivered={'0'} >}SALES)

IM CHOOSING ON OF THE VALUES IN THE LIST BOX

END I WANT TO SEE THE RESAULT OF THE EXPRESSION-

sum({<SO_DELIVERED_STATUS=,DELIVERY_STATUS={"Delivered on time"}>}&_Del_Measure1

ITS NOT WORKING

HOW CAN I DO IT?

ADI

Re: expression

Anil_Babu_Samineni — Tue, 02 Aug 2016 07:52:00 GMT

sum({<SO_DELIVERED_STATUS=,DELIVERY_STATUS={"Delivered on time"}>}QTY) as QTY

sum({<SO_DELIVERED_STATUS=,DELIVERY_STATUS={"Delivered on time"},Delivered= >}SALES) as SALES

sum({<SO_DELIVERED_STATUS=,DELIVERY_STATUS={"Delivered on time"},Delivered={'0'} >}SALES) as ZeroSales

And then Merge QTY & SALES & ZeroSales as _Del_Measure1 then use this Don't dimension. I suggest you don't use Calculated Dimensions

Please let me know, If i am wrong?

Re: expression

antoniotiman — Tue, 02 Aug 2016 08:09:51 GMT

Try

num(sum({<SO_DELIVERED_STATUS=,DELIVERY_STATUS={"Delivered on time"}>} $(=_Del_Measure1)

Regards,

Antonio

Re: expression

jonathandienst — Tue, 02 Aug 2016 08:18:57 GMT

To make sure the expression will work even if nothing is selected:

=sum({<SO_DELIVERED_STATUS=,DELIVERY_STATUS={"Delivered on time"}>}$(=MaxString(_Del_Measure1))